Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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.

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Differential Geometry

Authors: Christian Bar

1st Edition

051173123X, 9780511731235

More Books

Students also viewed these Mathematics questions