Question

these are for statistics

Mailings Reviuw References Layout Design Insert EE A A A AasbCcDdEe Calibri (Body) 11 A Normal abe X, x A U ce Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. SAT VACT Claswwork You and your friend want to compare your test results. You eamed a 1245 on the SAT's and your friend earned a 27 on the ACT. Use the information from the table below to determine who did better on their respective test. Justify your Wha answer. ACT Mean 20 Standard Deviation 6.1 SAT Mean 1060 Standard Deviation 195 Wou IQR The table below is a sample of SAT scores from a local high school. 1090 12564 1095 993 1274 912 1078 1125 1384 996 1234 1113 1087 1402 1387 974 1578 987 1589 1301 1145 879 100 1346 1498 1246 1148 1007 1105 1459 Calculate the sample mean, median, and mode. Calculate the 5 number summary. Graph the 5 number summary on a box and whisker plot using Statkey, Describe the shape. What score would be at the 75 percentle? What score would be at the 90 percentile? Page 1 of 2 188 Words English (US) MacBook Air

Answer 1

#1 SAT Vs ACT

we can compare scores by converting them to standardized z-scores.

SAT

X = 1245

mean = u = 1060

stad. dev. = s = 195

Z = ( X - u )/s

Z = (1245-1060)/195 = 0.95

ACT

X = 27

mean = u = 20

stad. dev. = s = 6.1

Z = ( X - u )/s

Z = ( 27 - 20)/6.1 = 1.15

Friends , z score is higher so he did better.

Tell me what you want to do.. 8 Insert File Home Insert Page Layout Formulas Data Review View Developer Add-ins XLSTAT . Cut Calibri - 11 AA === Wrap Text General 6 Copy Paste BIU - - - A S Format Painter SE Merge & Center - $ % , Clipboard Font Alignment Number B20 X for 2 A B C D E F G H I Conditional Format as Cell Formatting Table Styles Styles J K L 4 5 6 1090 1256 1095 1125 1384 996 993 1274 912 | 1234 L 1113 1087 1402 1006 1148 1387 974 1578 987 1 589 1301 1078 1498 1459 1145 1346 1007 879 1246 1105 Mean= Median= Mode = 1189.8 =AVERAGE(A4:J6) 1135 =MEDIAN(A4:36) #N/A =MODE(A4:J6) 5 number summary Min = 879 =MIN(A4:26) Q1 = 1024.75 =QUARTILE(A4:36,1) 1135 =QUARTILE(A4:36,2) Q3 = 1334.75 =QUARTILE(A4:36,3) Max = 1589 =MAX(A4:36) Q2 = IQR = Q3 - Q1 = Q3 +1.51QR = 310 1799.75 75th Percentile => Q3 = 1334.75 1334.75 1462.9 EPERCENTILE(A4:26,0.9) 90th Percentile => Since 1600 < Q3 +1.5IQR its not an outlier