Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Affordable Care Act created a marketplace for individuals to purchase health care plans. In 2014, the premiums for a 27-year-old for the bronze level
The Affordable Care Act created a marketplace 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 Table 2.
Table 2: Data of Health Insurance Premiums | |||||
$118 | $120 | $121 | $125 | $132 | $139 |
$139 | $141 | $143 | $145 | $151 | $153 |
$156 | $159 | $162 | $163 | $165 | $166 |
$170 | $170 | $176 | $177 | $181 | $185 |
$185 | $186 | $190 | $192 | $194 | $195 |
Bin range |
111-120 |
121-130 |
131-140 |
141-150 |
151-160 |
161-170 |
171-180 |
181-190 |
191-200 |
In Excel, create a histogram of the data using the bin width table above. Be sure to label the axes and add a title.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started