For Grafa Only Part II

profilesunshine1212
week_2q.xls

Sheet1

ANSWERS
1) I could not create the chart for this one...If the sales were $80,000; The sales for October - December were_____% of yearly sales. Note: Type an integer or decimal rounded to the nearest tenth.
2) The family budget is illustrated in the figure to the right. What percent of take-home pay is sppent for education if education, savings, and miscellaneous funds are used for education? Food $350 Housing $400 Insurance $80 Education $144 Personal $70 Miscellaneous $70 Clothing $170 Savings $170 Transportation $146
3) Weekly expenses of students taking a business mathematics class are shown in the table on the right. a) Find the mean. b) Find the median. c) Find the mode. NOTE: Round to the nearest whole number. 89 48 78 152 70 86 93 80 54 75 86 99 88 90 86 96 101 96 79 94 56 78 81 83 109 77
4) In the table on the right there are grades that were earned by students on a midterm business math exam. What percent of students earned a grade below 80 is ___%. NOTE: Round to the nearest whole number. 71 81 68 88 90 83 98 74 71 84 91 65 87 64 99 71 87 96 88 97
5) Find the standard deviation of a series of ACT scores listed. NOTE: Type an integer or decimal rounded to the nearest hundredth. 28, 26, 16, 14, 21
6) The data shows the total number of employee medical leave days taken for on -the -job accidents in the first six months of the year: 18, 12, 21, 15, 24, 18. Find the sum of squares if the deivations from the mean.
7) Use the hourly rates on the right (rounded to the nearest whole dollar) for 35 support employees in a private college to complete the frequency distribution and find the grouped mean. $15 $18 $6 $9 $11 $12 $14 $11 $12 $17 $17 $25 $17 $28 $19 $16 $12 $10 $11 $12 $16 $26 $16 $16 $25 $16 $16 $13 $7 $15 $11 $11 $15 $15 $8
Complete the class frequency table:
Class interval Class frequency Midpoint
6 thru 10 ___ 8
11 thru 15 ___ 13
16 thru 20 ___ 18
21 thru 25 ___ 23
26 thru 30 ___ 28
Total ___
8) Accountants often use the median when studying for various businesses. What is the median of the following salay list: $32,084; $21,934; $27,512; $43,782; $38, 860; $25,997?

Sheet2

Sheet3