Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Given: Measured compressive strength of concrete as a function of curing time Curing time Compressive strength of concrete (MPa 0.1 17 23 26 28
3. Given: Measured compressive strength of concrete as a function of curing time Curing time Compressive strength of concrete (MPa 0.1 17 23 26 28 29 30 14 21 28 in (a) Using Excel, prepare a scatter chart with curing time on the horizontal ais 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 your scanned engineering paper (b) Use linear interpolation and manual calculation to estimate the compressive strength of concrete for 10 and 25 days curing time (c) Check your answers in "b" with the Excel interpolation tool that you made for one of your computational exercises. Use the snipping tool to copy your calculator results for both curing times into your scanned engineering paper (d) Compute the compressive strength of concrete for curing times of 10, 25, and 100 day:s using your fitted trend line. Perform these calculations by hand on your scanned engineering paper (e) 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 3. Given: Measured compressive strength of concrete as a function of curing time Curing time Compressive strength of concrete (MPa 0.1 17 23 26 28 29 30 14 21 28 in (a) Using Excel, prepare a scatter chart with curing time on the horizontal ais 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 your scanned engineering paper (b) Use linear interpolation and manual calculation to estimate the compressive strength of concrete for 10 and 25 days curing time (c) Check your answers in "b" with the Excel interpolation tool that you made for one of your computational exercises. Use the snipping tool to copy your calculator results for both curing times into your scanned engineering paper (d) Compute the compressive strength of concrete for curing times of 10, 25, and 100 day:s using your fitted trend line. Perform these calculations by hand on your scanned engineering paper (e) 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
Step 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