What is the estimated compressive strength based on the RM

Assignment Help Applied Statistics

Reference no: EM132262700

Assignment -

The purpose of this assignment is to apply multiple regression concepts, interpret multiple regression analysis models, and justify business predictions based upon the analysis.

For this assignment, you will use the "Strength" dataset. You will use SPSS to analyze the dataset and address the questions presented. Findings should be presented in a Word document along with the SPSS outputs.

The compressive strength (Y) of concrete is influenced by the mixing proportions and by the time that it is allowed to cure, although the exact relationship between the strength and the components is unknown. The provided data includes the results of n = 1030 concrete strength experiments that include the following:

1. Strength (in MPa): The compressive strength of the concrete.

2. Age (in days): The number of days the concrete was allowed to cured.

3. Coarse_Aggregate (in kg/m³): The proportion of coarse aggregate in the mix.

4. Fine_Aggregate (in kg/m³): The proportion of fine aggregate in the mix.

5. Cement (in kg/m³): The proportion of cement in the mix.

6. Slag (in kg/m³): The proportion of furnace slag in the mix.

7. Superplasticizer (in kg/m³): The proportion of plasticizer in the mix.

8. Water (in kg/m³): The proportion of water in the mix.

9. Ash (in kg/m³): The proportion of fly ash in the mix.

Part 1: Derive various transformations of compressive strength to determine which transformation, if any, results in a variable that most closely mimics a normal distribution. To do this, plot Q-Q plots after each transformation listed below, and decide which one should be used to build a multiple linear model. Explain your answer and provide the SPSS output as an illustration.

1. Strength (no transformation)

2. Square root of Strength

3. Squared Strength

4. (Natural) Log of Strength

5. Reciprocal of Strength

Part 2: Based on the transformation selected in Part 1, build a multiple linear regression model with all eight predictors.

1. Use t-tests to determine if any of the predictors significantly affect the compressive strength of concrete. Explain why each variable should or should not be included in the model. Assume α = 0.05. Show the appropriate model results to explain your answer.

2. If any predictors from question 1 are found to be not significant, remove them and re-run the model to create a reduced model (RM). Are all the remaining variables still statistically significant? Show the appropriate model results to explain your answer.

3. Based on the RM, should there be concern about multicollinearity among the predictors selected? Show the appropriate model results to explain your answer.

4. After fitting the RM, derive the residual plot (standardized residuals vs. standardized predicted values) and normal probability plot. Interpret each plot.

5. What is the coefficient of determination, R², of the RM? How would you interpret the R²?

6. Based on the RM, what would be the new estimated compressive strength that is currently 50 MPa, after a 10-day increase in curing time? Assume all other predictors are held constant.

7. How would you interpret the intercept (constant) in the RM? Does the interpretation make sense given the data you used to build the RM?

Part 3: Given the following components and aging time below, what is the estimated compressive strength based on the RM?

1. Age: 50 days

2. Coarse_Aggregate: 900 kg/m³

3. Fine_Aggregate: 600 kg/m³

4. Cement: 300 kg/m³

5. Slag: 200 kg/m³

6. Superplasticizer: 7 kg/m³

7. Water: 190 kg/m³

8. Ash: 70 kg/m³

Part 4: What is a 95% confidence interval of the estimate in Part 3? How would you interpret the 95% confidence interval? (Hint: Use the SPSS scoring wizard to address this question.)

Note - Need the SPSS outputs and the word document for the all the 4 parts. Find attached the dataset and FOR PART 4 - Read "Scoring Wizard Version 20.0.0," located on the IBM website.

Attachment:- Assignment Files.rar

Reference no: EM132262700

Questions Cloud

Paper about making risk management plan : The teacher want me to make paper about making risk management plan using iso 31000 for a company, please describe it in details.

Identify three mobile OSs and three personal computerOSs : Identify three mobile OSs and three personal computerOSs. Explain advantages and disadvantages of each one. Describe each OS. The total wording for.

What do you think of the real criteria : What do you think of the real criteria to be used in making a hiring decision?

How did wells fargo survive the financial crisis in 2007 : How did wells fargo survive the financial crisis in 2007 to 2009, which affected the remote environment that was plaque by economic and political problems?

What is the estimated compressive strength based on the RM : Given the following components and aging time below, what is the estimated compressive strength based on the RM

The premise of the justice system : The constitution, unfortunately, sides with the judge. The premise of the justice system is their judges are impartial and infallible.

Large number of replications of simulation would be made : The main reason that a large number of replications of a simulation would be made is:

What are the biggest and most powerful interest groups : The recent actions of interest groups and the effect on the legislative agenda of Congress have changed how congress is run in multiple ways.

An analyst to monitor their existing systems : an analyst to monitor their existing systems and make modifications.

User Account

All Pages