Question

Given: Measured compressive strength of concrete as a function of curing time Curing time (days) Compressive strength of concrete (MPa) 17 23 26 28 29 30 14 21 28 (a) Using Excel, prepare a scatter chart with curing time on the horizontal axis and compressive strength on the vertical axis. Show only black markers with no lines and format your chart in the usual way (Times new roman 16 bold axis numbers and Times new roman 18 bold axis titles). Add a logarithmic trend line to your chart and show as a dashed black line. Be sure to add the trend line equation and R2 to your chart (formatted as Times new roman 16 bold). Copy your chart into you r scanned engineering paper (b) Use the Excel interpolation tool you constructed in computational exercise 3 to estimate the compressive strength of concrete for 10 and 25 days curing time. Use the snipping tool to copy your calculator results for both curing times into your scanned engineering paper. e) Compute the compressive strength of concrete for curing times of 10, 25, and 100 days using your fitted trend line. Perform these calculations by hand on your scanned engineering paper (d) Compute the curing times required to achieve a compressive strength of 5 and 2 ksi using your fitted trend line. Perform these calculations by hand on your scanned engineering paper

Answer 1

please go through the following attachments

answer for a)

Curing time Compressive strength (Days) 0.1 2 (MPa) 0 14 21 28 23 26 28 29 30

35 30 E 25 20 2 15 10 30 29 ◆ 28 ◆26 23 *Compressive strength (MPa) 10 20 30 Curing time ( Days)

35 -30 E25 30 ◆23./ у = 5.820|n(x) + 11.5 ◆ Compressive ︵ 20 R" 0.882 strength (MPa) ︶ 10 Log. (Compressive strength 10 20 30 (MPa)) -5 Curing time ( Days)

ANSWER FOR b)

Formula for interpolation

=FORECAST(NewX,OFFSET(KnownY,MATCH(NewX,KnownX,1)-1,0,2), OFFSET(KnownX,MATCH(NewX,KnownX,1)-1,0,2))

forecast function FORECAST(E 7.OFFSET(D 5 :D 1 1 MATCH(F3. C5:C11,1)-1,0,2),OFFSET(C5:C11,MATCH(F3, C5:C11,1)-1,0,2)) FORECAST(x, known_y's, known_x's)

Interpolation match function offset function forecast function 25.14285714 10 days 28.85714286 20 days

Answer for c)

5.820 -O 5.820 n 115 25 days 30.2338 MPa 100 days -5.820 On 1100)ナ11-5 : 38.3020 Mfa

ANSWER FOR d)

6S76 MP sKs3 43 Ma 34 h385 820 Snl)5 (メ days 2 KS: )3, 7845 мед . 13.9845 5.820 In I*)5 9m(x) : 0:39 338