Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

The Affordable Care Act created a market place for individuals to purchase healt

ID: 3368901 • Letter: T

Question

The Affordable Care Act created a market place for individuals to purchase health care plans. In 2014, the premiums for a 27 year old for the bronze level health insurance are given in the following table ("Health insurance marketplace," 2013). (Use the data to answer questions 9 to 14) $114 $119 $121 S125 $132 $139 S139 $141$143 $145 151 $153 $15d $159| $16 S1631 $1? $1661 S170 $170176 $177 18 S185 S18S $186 $8189 $190 $192 $196 $203$204 $219 254 S286 9. Create a frequency distribution, relative frequency distribution, and cumulative frequency distribution using 5 classes. (5 pts) 10. What is the frequency associated with the SECOND class? (2 pts) 11. What is the frequency associated with the FOURTH class? (2 pts) 12. What is the relative frequency associated with the SECOND class? (2 pts) 13. What is the relative frequency associated with the FOURTH class? (2 pts) 14. What is the cumulative frequency associated with the FOURTH class? (2 pts)

Explanation / Answer

Solution9

Solution10:

18

Solutio11:

1

Solution12:

0.5

solution13:

0.0278

Solution14:

35

ALL ANSWERS ARE FROM THE EXCEL TABLE ATTACHED

Frequency Table Class Count(Also called Frequency) RELATIVE FREQUENCY=FREQUENCY/TOTAL cumulative freq FIRST 110-149 10 0.277777778 10 SECOND 150-189 18 0.5 28 THIRD 190-229 6 0.166666667 34 FOURTH 230-269 1 0.027777778 35 FIFTH 270-309 1 0.027777778 36 Total 36 1