BUS8375 – Research and Data Analysis Assessment

Instructions:

Review the subset of data that has been extracted from the Sustainable Development Report 2022 (https://dashboards.sdgindex.org/).  The data is located in Week 11 on eConestoga as well as in the Evaluations Module under Assignment #4.  Using this data, complete the following analysis:

• Select a Sample from the Data

Data is available for 163 countries in this subset.  For the purposes of this assignment we will use a smaller sample of data for the majority of our analysis.  Randomly select 25 countries from the list of countries that will act as your sample dataset for this population.  

Create a worksheet within your excel document that contains the data for your randomly selected sample of 25 countries. NOTE: This is the data set that you will use for all questions except 3b, c, and d. (2 pts)

• Central Tendency of Coded Data – SDG12 Responsible Consumption and Production

The dashboard rating (indicated by a colour) can be considered ordinal data.  

1. For your data sample, code the Goal 12 Dashboard data.  (2 pts)
2. Calculate the Mode, Median, Mean, and Interquartile Range for your coded response. (4 pts)

• Measure of Dispersion – SDG 3 Good Health and Well Being

1. For your data sample, manuallycalculate the standard deviation of the Goal 3 Score in excel (be sure to show your work).  (5 pts).  
2. For the entire population (i.e. all countries), calculate the standard deviation of the Goal 3 Score in excel (you may use the standard deviation excel formula or manually calculate). (1 pts)
3. Based on 3a and 3b, comment on whether or not your sample is representative of the population in two sentences or less. (1 pts)
4. Assume we had a normal distribution for the data we were looking at in Question 6b.  Between what range would you expect to find 68% of the data. (1 pts)

• Pie Chart: SDG 1 No Poverty
  1. Draw a pie-chart for your data sample that summarizes how countries are trending in achieving SDG 1 No Poverty.Hint: You will first need to create a frequency distribution table for each category (i.e. on track, moderately increasing, etc.).  (5 pts)
  2. Summarize the data in the pie-chart in two or less sentences (i.e. what is the chart telling us). (1 pts)

• Histogram: SDG 13 Climate Action
  1. Using the Goal 13 Scorefor your data sample, create a frequency distribution table using four (4) equal intervals (2 pts)
  2. Draw a histogram to present the data from your table (3 pts)
  3. Summarize the data in the histogram in two or less sentences (i.e. what is the data telling us?). (1 pts).  

• Scatterplot: SDG of Choice vs. Population
  1. Pick any one of the SDG Scoresthat you think might have a relationship with the overall 2022 SDG Index Score.
  2. Draw a scatterplot showing the 2022 SDG Index Scoreon the X axis and the Goal Score on the Y axis for your data sample. (3 pts)
  3. Summarize the data in the scatterplot in two sentences or less (i.e. what is the graph telling us). (1 pts)
  4. From your scatterplot, identify the formula for your regression line.  To do this add a Simple Linear Trendline.  Be sure to select “Display Equation on Chart” in the formatting window of the trend line.  (2 pts)
  5. Using the formula you found in 6d, what is the predicted value of a countries Goal Score for your chosen SDG if they have a 2022 SDG Index Score of 75? (2 pts)

• Student’s Choice
  1. Select one (or two) variable(s) that you would like to create a visual summary for
  2. Select an appropriate method to display your data that we have not already practiced above (i.e. pareto chart, stem and leaf plot, or box plot).  
  3. Calculate the Central Tendency for your variable (based on data type, select the appropriate method) (2 pts).  
  4. Generate a chart to present the data for your selected variable (4 pts)
  5. Summarize the data in the chart in two or less sentences (i.e. what is the data telling us?). (1 pts).  

Deliverable:

Submit an Excel document with your responses to the above.  Please be sure to show detailed calculations where required.  It is recommended to use one worksheet per question.

Submit the assignment in the Assignment drop box, before the due date.  Submissions more than 5 minutes late will be penalized 10%.  Assignments received after one day late will be penalized another 10%.  Late submissions will not be accepted after 2 days late.

Grading:

Grading for this assignment will be based upon:

1. Visual appearance of your graphs – title, legend, axes labels
2. Accuracy of your response
3. Calculations shown where required.
4. Explanation of results

The total grade for this assignment is 42 points and the assignment is worth 15% of your final grade.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects. Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank