This is a discussion question for week 3 for MATH 300 Introduction to Statistics

Week 3 Discussion

"Data Description" (Please respond to the following.)

• The table in the e-Activity shows Average Insurance Costs by State. I have attached the table as an Excel file to make it easier to do the calculations required for this discussion question. Be sure to check out the video in Instructor Insights for an easy way to calculate the standard deviation in Excel!
• From the table, select five (5) states at random and calculate the mean and standard deviation for average insurance costs. Next, calculate the mean and standard deviation for average insurance costs for all 51 states. Compare and contrast the means and standard deviations for the 5 states you selected and all 51 states. How representative was your sample?
• Insurance Cost by State.xlsx