Question: I just need the excel formula. If excel can't do the calculation, then I need help setting it up. The data is in two parts

 I just need the excel formula. If excel can't do thecalculation, then I need help setting it up. The data is in

I just need the excel formula. If excel can't do the calculation, then I need help setting it up. The data is in two parts because it was long.

two parts because it was long. Perform the statistical calculations. Concrete BreakingStrengths (pounds per square inch (PSI) 1148 1229 sample size = 50

Perform the statistical calculations. Concrete Breaking Strengths (pounds per square inch (PSI) 1148 1229 sample size = 50 906 1168 mean = 1167.8 1167 1187 sample standard deviation = 133.8 1011 1261 find and interpret an 80% confidence 1113 interval ( round to 1 place) = 1318 1252 If the data is normally distributed, find 1147 the percent of test cylinders that would 1119 be expected to break at more than 1300 1119 PSI (round to 3 places) = 1023 1115 1024 Treating the data as a normally 1320 distributed, find the probability that 12 1187 test cylinders will have a combined 1330 average breaking strength under 1150 1249 PSI (round to 3 places) = 1294 1212 1158 find the PSI number that defines the top 1024 15% breaking strengths (round to a 967 whole number) = 12381335 1211 993 1243 1024 976 954 1202 1380 1256 1144 924 996 1387 1022 1171 1164 1262 1384 1378 1377 1055 1266

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!