Exercise 1: Histogram Exercise 1 in the text: You may use any spreadsheet program. Submit a Word document with a screenshot from your computer showing the histogram. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Execise 2: Calculating Quartiles Exercise 2 from the text: Use any spreadsheet program. Submit a Word document showing a screen shot from your computer with the quartiles underlined or highlighted. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Exercise 3: Central Tendency Exercise 3: Use any spreadsheet program. Submit a Word document with a screen shot from your computer showing the highlighted median. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Exercise 4: Dispersion Exercise 4: Use any spreadsheet program. Using the data provided in the text, submit a Word document with a screen shot from your computer highlighting the range, standard deviation, IQR, and outliers of Add-on Sales. Comment your images so the viewer knows what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results Exercise 5: Pearson Correlation Exercise 5: Use any spreadsheet program. Using the data provided in the text, create a scatter plot and calculate the Pearson Correlation Coefficient. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. Activity 2: Exploring Sales Data There is no activity 1. Activity 2: Use the attached dealerships.csv file and any spreadsheet program. Submit a Word document with a screen shot from your computer of your solutions to questions 2 – 7 in the text. Highlight your results. Comment your images with a sentence or so of description in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the resultsdealerships1.csv
The post Calculating Quartiles first appeared on Template.