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 results