create a chart and a table of data.
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?
