Question: This is a discussion question for week 3 for MATH 300 Introduction to Statistics Week 3 Discussion Data Description (Please respond to the

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!