## Question

###### Given: Measured compressive strength of concrete as a function of curing time Curing time (days) Compressive...

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

## Answers

please go through the following attachments

answer for a)

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))

Answer for c)

ANSWER FOR d)

Curing time Compressive strength (Days) 0.1 2 (MPa) 0 14 21 28 23 26 28 29 3035 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)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 days5.820 -O 5.820 n 115 25 days 30.2338 MPa 100 days -5.820 On 1100)ナ11-5 : 38.3020 Mfa6S76 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

#### Similar Solved Questions

1 answers

##### Choose a population that interests you. Using one or more conceptual models of social determinants of...

Choose a population that interests you. Using one or more conceptual models of social determinants of health, suggest ways for developing a conceptual framework, collecting empirical data, and applying it to design, implementation, and evaluation of an intervention to 1) improve the beneficial effec...

1 answers

##### How do you simplify #(x^2+5x+6)/(x+1) * (x^2-1)/(x+3)#?

How do you simplify #(x^2+5x+6)/(x+1) * (x^2-1)/(x+3)#?...

1 answers

##### A horizontal length of current-carrying wire is suspended from two identical flexible leads that are under...

A horizontal length of current-carrying wire is suspended from two identical flexible leads that are under tension due to the weight of the wire. The wire is oriented at right angles to a uniform magnetic field that has a magnitude of 4T and is directed out of the screen of the figure. The length of...

1 answers

##### Can you show me how to to and expain to me how to conplete this table?!...

Can you show me how to to and expain to me how to conplete this table?! complete and tell me how what to do? L Complete the following cost table describing the short run costs for Magenta Magnets: ti 10 Total Product (magnets) Total Fixed Costs (TFC) Total Variable Costs (TVC) Total Costs (TC) ...

1 answers

##### Piezometer and a pitot tube are put in a 1 ft diameter pipe repectivley full of...

piezometer and a pitot tube are put in a 1 ft diameter pipe repectivley full of water. there is a pressure diffence of 0.4 ft increase. what is the Q...

1 answers

##### Nws (similar to) sted trial balance of Armstrong Corporation at December 31 shows that sales revenue...

nws (similar to) sted trial balance of Armstrong Corporation at December 31 shows that sales revenue for the year was $560,000 and other revenue ld for that same period was $270,000, while other expenses totaled $190,000. The corporation declared and paid dividends of $19,00 of retained earnings bef...

1 answers

##### BASE CASE CHANGE SCENARIO 1 CHANGE SCENARIO 2 United States 500,000 500,000 500,000 Canada 500,000 550,000...

BASE CASE CHANGE SCENARIO 1 CHANGE SCENARIO 2 United States 500,000 500,000 500,000 Canada 500,000 550,000 400,000 Mexico 300,000 330,000 240,000 COST OF GOODS SOLD 1,300,000 1,380,000 1,140,000 Price paid per gallon $1.30 $1.38 $1.14 S...

1 answers

##### Compute the expected return given these three economic states, their likelihoods, and the potential returns: (Round...

Compute the expected return given these three economic states, their likelihoods, and the potential returns: (Round your answer to 2 decimal places.) Economic State Probability Return Fast growth 0.26 60 % Slow growth 0.37 27 Recession 0.37 –39...

1 answers

##### Arona Corporation manufactures canoes in two departments, Fabrication and Waterproofing. In the Fabrication Department, fiberglass panels...

Arona Corporation manufactures canoes in two departments, Fabrication and Waterproofing. In the Fabrication Department, fiberglass panels are attached to a canoe-shaped aluminum frame. The canoes are then transferred to the Waterproofing department to be coated with sealant. Arona uses a weighted- a...

1 answers

##### Help needed in python ! Classes can not be used ! Thanx Many games have complex...

Help needed in python ! Classes can not be used ! Thanx Many games have complex physics engines, and one major function of these engines is to figure out f two objects are colliding. Weirdly-shaped objects are often approximated as balls. In this problem, we will figure out if two balls are collidi...

1 answers

##### Q1. Hat Inc. is thinking of investing in a new machine to produce baseball caps. The new...

Q1. Hat Inc. is thinking of investing in a new machine to produce baseball caps. The new machine will cost $1M and will last for 4 years. At the end of 4 years salvage value is estimated at $100k. Executives believe they will be able to generate $750k in sales next y...

1 answers

##### 9. (2 pts) Which is the major product formed when the compound shown below is heated?...

9. (2 pts) Which is the major product formed when the compound shown below is heated? CH3CH2C-CHEC-OH 10. (2 pts) What is the IUPAC name for the following compound? H2N COOH 11. (4 pts each) For each reaction complete the following: 1. Name the starting compound(s). 2. Name the type of reaction 3. C...

1 answers

##### Explain in your own 200 words what are the various policy initiatives that the federal government has followd with respect to tge agricultural policy in the united states?

explain in your own 200 words what are the various policy initiatives that the federal government has followd with respect to tge agricultural policy in the united states?...

1 answers

##### How many aluminum ions are contained in 0.0128 uL of a 2.56 * 10 ^-4 M...

How many aluminum ions are contained in 0.0128 uL of a 2.56 * 10 ^-4 M solution of Al(NO3)3...

1 answers

##### DES Give the group number (e.g., 1A(1) and general electron configuration (e.g., nsnp each electron-dot symbol:...

DES Give the group number (e.g., 1A(1) and general electron configuration (e.g., nsnp each electron-dot symbol: 2.5 points eBook Group number: Print Electron configuration: References (b) Group number: Electron configuration:...

1 answers

##### The Campus Division of All-States Bank has assets of $2,800 million. During the past year, the...

The Campus Division of All-States Bank has assets of $2,800 million. During the past year, the division had profits of $275 million. All-States Bank has a cost of capital of 5 percent. Ignore taxes. Required: a. Compute the divisional ROI for the Campus Division. (Enter your answer as a percentage r...

1 answers

##### A: It is desired to prepare 700 mL of 0.150 normal Ba(OH)2for use in the reaction:...

A: It is desired to prepare 700 mL of 0.150 normal Ba(OH)2for use in the reaction: 2 HCl + Ba(OH)2-------BaCl2+ 2 H2O How many grams of Ba(OH)2are needed? ___ g B: For the following reaction: H2S + 2 KOH--- K2S + 2 H2O Calculate the normality of a solution that contains 3.80 grams of H2S in 784 ...

1 answers

##### QUESTION 11 a value represents the 95th percentile, this means that: 0 95% of all values...

QUESTION 11 a value represents the 95th percentile, this means that: 0 95% of all values are below this value 0 95% of all values are above this value 0 95% of the time you will observe this value O there is a 5% chance that this value is incorrect O there is a 95% chance that this value is correct ...