Question

gi HW,2 and Recitaiton 2 × Φ Chapter 2 Filled.pdf 2%20and% //sakai.uri.edu/access/content/group/702e45af-c2f8-43ca-a53c-9137c003efa/H Use Excer to answer this questro credit. Exercise 2.90 (data posted on SAKAI) on page 70 in the textbook (posted on Sakai). Answer the following questions: a. b. c. d. Determine a frequency distribution Obtain a relative frequency distribution Plot a frequency histogram based on your results from part (a) Plot a relative frequency histogram based on your results from part (b) 2. The starting annual salaries for a sample of 35 liberal arts graduates: Note: you could answer this question ustos oel or by hand. Your choice Relative Starting Salary ($thousands) Frequency 0.086 0.086 0.143 0.257 0.257 0.114 0.029 0.029 3 25 (26) 26 (27) 27 (28) 28 (29) 29 (30) 30 (31) 31 (32) 32 - (33) 9 9 4 a. Construct the cumulative frequency distribution b. Construct the cumulative relative frequency distribution c. Plot the ogive. d. Using your plot in part (c), find an approximate value for the median starting annual salary for liberal-arts graduates. 3. Do Exercise 2.99 on page 71 in the textbook. For parts (a) and (b) in the exercise construct the ordered stem-and-leaf diagram. 4. Do Exercise 3.20 on page 101 in the textbook. 5. Several neurosurgeons wanted to determine whether a dynamic system (Z-plate) reduced the number of acute postoperative days spent in the hospital relative to a static system (ALPS plate). Researchers at Arizona State University obtained the

having trouble understanding what to do. can someone help please I have Excel it's not working

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The given data can be further analyzed as per below table

$Salary('000) $Frequency $Cum.Frequency $Frequency(Rel.) $Rel.Frequency(Cum.)
25-(26) 3 3 0.0857 0.0857
26-(27) 3 6 0.0857 0.1714
27-(28) 5 11 0.1429 0.3143
28-(29) 9 20 0.2571 0.5714
29-(30) 9 29 0.2571 0.8286
30-(31) 4 33 0.1143 0.9429
31-(32) 1 34 0.0286 0.9714
32-(33) 1 35 0.0286 1.0000

Hence the cumulative frequency distribution can be sketched as per below

40 0 30 20 10 25 26 27282930 31 32 33

The ogive is also the same plot, except that the y-values are scaled from 0 to 100, 100 being achieved at the maximum frequency value viz. 35. So it looks like below

0 100 80 60 40 20 25 26 27282930 31 32 33

The median can be calculated by finding the value at which the ogive is crossing the value of 50. Clearly, that value is in the range $28,000 – 29,000.

However, to get the more accurate value, we can go back to the table baove and extrapolate the values to find the precise value at which the cumulative relative frequency should be 0.5. This value comes to be

\mathrm{Salary(Median)}=28+ \frac {0.5-0.3143} {0.5714-0.3143}\approx 28.722

That is, the median is approximately $28,722

Add a comment
Know the answer?
Add Answer to:
having trouble understanding what to do. can someone help please I have Excel it's not working...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT