statistical mathematics and analysis Assignments | Collage Homework Help

Create two new tabs/sheets in your Excel file (the same Excel file from your Module 1 Assignment and Discussion – unless you had to select a new county due to missing data), one for the each of these winter seasons. Copy and paste the data for each of these two winters to a new sheet and give descriptive names to the tabs.

For each of these two winters, use StatCrunch to create a histogram of the snowfall. At the end of Chapter 2 in the textbook is a Tech Tips section with instructions for doing so in StatCrunch.

When you click on Graph in StatCrunch you will have the ability to set many features. You will want to experiment a bit here. The bins should start at 0, but experiment with several different widths. Once you have found a useful width, be sure to use the same width for both histograms. Include relevant labels for the x-axis, y-axis, and title.

Cut and paste each histogram into the appropriate sheet of your Excel file. That is, the two new tabs you have with the data should now also include the associated histograms. Make sure to save your file. You should be working from the same single Excel file for the Modules 1 through 3 Assignment and Discussions, creating new sheets/tabs as we continue our work in each module.

For your discussion post, summarize the important features of these two histograms using the vocabulary of Section 2.2 of our textbook. Attach your Excel file to your main discussion post and also include within your discussion post the two histograms you created (see here for how to insert images into the discussion).