Reference no: EM13805790
Project: Regression and Correlation Analysis
Using MINITAB perform the regression and correlation analysis for the data on CREDIT BALANCE (Y) and SIZE (X) by answering the following.
1. Generate a scatterplot for INCOME ($1000) vs. CREDIT BALANCE($), including the graph of the "best fit" line. Interpret.
2. Determine the equation of the "best fit" line, which describes the relationship between INCOME and CREDIT BALANCE.
3. Determine the coefficient of correlation. Interpret.
4. Determine the coefficient of determination. Interpret.
5. Test the utility of this regression model (use a two tail test with α =.05). Interpret your results, including the p-value.
6. Based on your findings in 1-5, what is your opinion about using CREDIT BALANCE to predict INCOME? Explain.
7. Compute the 95% confidence interval for beta-1 (the population slope). Interpret this interval.
8. Using an interval, estimate the average income for customers that have credit balance of $4,000. Interpret this interval.
9. Using an interval, predict the income for a customer that has a credit balance of $4,000. Interpret this interval.
10. What can we say about the income for a customer that has a credit balance of $10,000? Explain your answer.
11. In an attempt to improve the model, we attempt to do a multiple regression model predicting INCOME based on CREDIT BALANCE, YEARS and SIZE.
Using MINITAB run the multiple regression analysis using the variables CREDIT BALANCE, YEARS and SIZE to predict INCOME. State the equation for this multiple regression model.
12. Perform the Global Test for Utility (F-Test). Explain your conclusion.
13. 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.
14. Is this multiple regression model better than the linear model that we generated in parts 1-10? Explain.
|
Write a report to your manager about the results
: Write a report to your manager about the results, distilling down the results in a way that would be understandable to someone who does not know statistics. Clear explanations and interpretations are critical.
|
|
Payroll program for a large organization
: You have been tasked with building a payroll program for a large organization with offices spread across the United States. The company has one larger data center that each office connects to via a wide area network (WAN)
|
|
Essential for advancement corporation
: It is critical that skilled scientists and technicians be hired to ensure the proper development of pharmaceuticals through clinical trials. It is absolutely essential for Advancement Corporation to continuously recruit, select, and train qualifie..
|
|
How much should you set aside now to cover these payments
: Suppose you plan to send your daughter to college in three years. You expect her to earn two-thirds of her tuition payment in scholarship money, so you estimate that your payments will be $10,000 a year for four years. To estimate whether you have se..
|
|
Determine the coefficient of correlation
: 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.
|
|
Ethics and corporate responsibility in the workplace
: Analyze and evaluate laws that protect against discrimination in the workplace - Examine and assess employee rights to health and safety in the workplace.
|
|
Develop a means for communicating with existing department
: To identify, plan, and execute this project, you must first develop a means for communicating with existing department heads in the research and development and sales departments.
|
|
Assignment on conflicting viewpoints essay
: Conflicting Viewpoints Essay
|
|
What should the price per share be
: Preferred stock has a dividend of $12 a year. The required return is 6%. what should the price per share be?
|