Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 the calculation, then I need help setting it up. The data is in two parts because it was long.
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 1266Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started