Throughout the term you will be actively calculating simple statistics and visualizing data. In this first assignment, you will use the attached data set to create a chart and a table of data. Note that formatting is key to data representation. Once you make your calculations and create the chart, interpret the information you observe in a short summary of 250 words.
Download the Demo Data file to create a chart and write a description and interpretation of the data represented.
Download and Save the Excel file to your computer or cloud.
Using the Demo Data file, create a chart that represents the number of fruit eaten per month for each fruit. This should be one (1) chart for all fruit.
Calculate the appropriate measure(s) of central tendency for fruit eaten per month. Sum the total fruit per month eaten. (Hint: Measures of central tendency are applied according to the level of measurement – fruit would be a _______ variable)
Copy the chart, and paste into a Word document as an Excel object.
Create a table in the document that includes the Total fruit eaten, as well as the applicable measure(s) of central tendency. Note: the table should include the names of the(each) measure in conjunction with the calculation.
Describe the data: What is the data about?
Explain why the chart type you selected is most appropriate for the representation of this data.
Explain your measure(s) of central tendency and what they say about the data.
Interpret the data: What does the chart show you? What fruit stands out to you and why?