Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Chirag Your Own Question

Chirag, Master's Degree

Category: Calculus and Above

Satisfied Customers: 12192

Experience: I have a Master's degree in Engineering and a very wide teaching experience of more than 25 years at various levels.

13269833

Type Your Calculus and Above Question Here...

Chirag is online now

Here is part C for tomorrow.Project Part C: Regression

This answer was rated:

★★★★★

Here is part C for tomorrow.

Project Part C: Regression and Correlation Analysis Back to Top

Using MINITAB perform the regression and correlation analysis for the data on CREDIT BALANCE (Y) and SIZE (X) by answering the following.

Generate a scatterplot for CREDIT BALANCE vs. SIZE, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between CREDIT BALANCE and SIZE. Determine the coefficient of correlation. Interpret. Determine the coefficient of determination. Interpret. Test the utility of this regression model (use a two tail test with α =.05). Interpret your results, including the p-value. Based on your findings in 1-5, what is your opinion about using SIZE to predict CREDIT BALANCE? Explain. Compute the 95% confidence interval for beta-1 (the population slope). Interpret this interval. Using an interval, estimate the average credit balance for customers that have household size of 5. Interpret this interval. Using an interval, predict the credit balance for a customer that has a household size of 5. Interpret this interval. What can we say about the credit balance for a customer that has a household size of 10? Explain your answer.

In an attempt to improve the model, we attempt to do a multiple regression model predicting CREDIT BALANCE based on INCOME, SIZE and YEARS.

Using MINITAB run the multiple regression analysis using the variables INCOME, SIZE and YEARS to predict CREDIT BALANCE. State the equation for this multiple regression model. Perform the Global Test for Utility (F-Test). Explain your conclusion. Perform the t-test on each independent variable. Explain your conclusions and clearly state how you should proceed. In particular, which independent variables should we keep and which should be discarded. Is this multiple regression model better than the linear model that we generated in parts 1-10? Explain. All DeVry University policies are in effect, including the plagiarism policy. Project Part C report is due by the end of Week 7. Project Part C is worth 100 total points. See grading rubric below.

Summarize your results from 1-14 in a report that is three pages or less in length and explains and interprets the results in ways that are understandable to someone who does not know statistics.

Submission: The summary report + all of the work done in 1-14 (Minitab Output + interpretations) as an appendix.

Format:

Summary Report Points 1-14 addressed with appropriate output, graphs and interpretations. Be sure to number each point 1-14.

Project Part C: Grading Rubric Back to Top

Category Points % Description Questions 1 - 12 and 14 - 5 pts. each 65 65 addressed with appropriate output, graphs and interpretations Question 13 15 15 addressed with appropriate output, graphs and interpretations Summary 20 20 writing, grammar, clarity, logic, and cohesiveness Total 100 100 A quality paper will meet or exceed all of the above requirements.

My computer tells me that the excel file has been successfully downloaded. I could also download all the files at my end. Please try again. The response can't be pasted on this page because the formatting will be lost and it will all look cluttered and useless.