PLEASE SOLVE A, B (for letter b, plot also the less-than ogive), and C USE MS EXCEL TO DRAW THE PLOTS or GRAPHS
Posted: Mon May 16, 2022 7:56 am
PLEASE SOLVE A, B (for letter b, plot also the less-than ogive), and C
USE MS EXCEL TO DRAW THE PLOTS or GRAPHS
Medicare's new medical plans offer a wide range of variations and choices for seniors when picking a drug plan (San Luis Obispo Tribune, November 25, 2005). The monthly cost for a stand-alone drug plan а varies from plan to plan and from state to state. The accompanying table gives the premium for the plan with the lowest cost for each state. Cost per Cost per Month (dollars) Month (dollars) State State Alabama 14.08 Colorado 8.62 Alaska 20.05 Connecticut 7.32 Arizona 6.14 Delaware 6.44 Arkansas 10.31 District of Columbia 6.44 California 5.41 contin
State Florida Georgia Hawaii Idaho Illinois Indiana lowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire Cost per Month (dollars) 10.35 17.91 17.18 6.33 13.32 12.30 1.87 9.48 12.30 17.06 19.60 6.44 7.32 13.75 1.87 11.60 10.29 State New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Cost per Month (dollars) 4.43 10.65 4.10 13.27 1.87 14.43 10.07 6.93 10.14 7.32 16.57 1.87 14.08 10.31 6.33 7.32 8.81 6.93 10.14 11.42 1.87 1.87 1.87 6.42 19.60 a. Use class intervals of $0 to <$3, $3 to <$6, $6 to <$9, etc., to create a relative frequency distribu- tion for these data. b. Construct a histogram and comment on its shape. c. Using the relative frequency distribution or the histogram, estimate the proportion of the states that have a minimum monthly plan of less than $13.00 a month
USE MS EXCEL TO DRAW THE PLOTS or GRAPHS
- Please Solve A B For Letter B Plot Also The Less Than Ogive And C Use Ms Excel To Draw The Plots Or Graphs 1 (47.36 KiB) Viewed 43 times
- Please Solve A B For Letter B Plot Also The Less Than Ogive And C Use Ms Excel To Draw The Plots Or Graphs 2 (44.54 KiB) Viewed 43 times
State Florida Georgia Hawaii Idaho Illinois Indiana lowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire Cost per Month (dollars) 10.35 17.91 17.18 6.33 13.32 12.30 1.87 9.48 12.30 17.06 19.60 6.44 7.32 13.75 1.87 11.60 10.29 State New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming Cost per Month (dollars) 4.43 10.65 4.10 13.27 1.87 14.43 10.07 6.93 10.14 7.32 16.57 1.87 14.08 10.31 6.33 7.32 8.81 6.93 10.14 11.42 1.87 1.87 1.87 6.42 19.60 a. Use class intervals of $0 to <$3, $3 to <$6, $6 to <$9, etc., to create a relative frequency distribu- tion for these data. b. Construct a histogram and comment on its shape. c. Using the relative frequency distribution or the histogram, estimate the proportion of the states that have a minimum monthly plan of less than $13.00 a month