Question

BUSA 2000: Statistical Analysis for Business Optional Extra Credit Assignment Directions: Use the data below to answer all of the following questions. Thirty American high school graduates and thirty American college graduates were surveyed and asked to report their post-tax annual salaries. Notice the standard deviations have already been calculated for you. $38,171 $27,959 $41,462 $33,903 $28,675 $29,031 $21,628 $34,531 $30,942 $21,660 $39,875 $16,947 $25,275 $31,258 $35,300 $34,165 $36,935 $46,513 $39,250 $37,772 $29,151 $28,299 $36.251 $22,637 $37,613 $30,732 $32,456 $32,786 $24,864 $28,935 Population) Standard deviation $600 $50,916 $66,597 $50,914 $46,745 $54,694 $56,222 $47,292 $60,338 $51,873 $48,000 $54.217 $54,984 $55,835 $62,192 $40,729 $46,206 $53,894 $60,627 $49,685 $49,147 $37,171 $42,463 $50,817 $46,409 $37,636 $64,954 $59,216 $62,925 $45,841 $55,588 Population) Standard deviation $700 1. Fill in the summary statistics table below Median Minimum Maximum

Answer 1

Answer to the question# 1)
Enter data in excel

7 1179 92320 6762292823698 9913227 5 2 5 2195895 2 e55365455546454354 5 151979251387 315285613620 136323531845 h775549675 s899768-56312857940162462 3 26636017694557 1 2 332212423332233233233343332232 01234567890123456789012 2345

.

The cell range values for high school is : B3 to B32

for college graduates = D3 to D32

we would be using these respective range of values for the further excel formulae

28 29 30 31 32 39250 24864 21660 37772 28935 31832.53 31857.00 16947.00 46513.00 29566.00 28393.00 31857.00 36764.00 8371.00 49685 45841 48000 49147 55588 52137.57 51394.50 37171.00 66597.00 29426.00 46881.75 51394.50 56125.25 9243.50 Fromula in excel "-average(range of values)" "-stdev(range of values)" "-min(range of values)" "-max(range of values)" "-maximum value - minimum value" "-quartile(range of values, 1)" "-QUARTILE (range of values, 2)" i quartile(range of values, 3)" "-03-01" Mean - Median Minimum Maximum - Range Q1- 02- 03 - QR 34 35 36 37 38 39 40 41 42