See attached file for data.
Need assistance in producing the charts, graphs and analysis associated with this project. This exercise involve multiple regression analysis.
We want to determine whether the size of the bill has an effect on the number of days the bill is late. The statistical analysis of the data involves regression analysis.
Questions you'll want to answer are:
1. Does the size of the bill somehow relate to the number of days the payment is late? If so, how? Find a model that can be used to predict how late a bill may be.
2. Does your answer depend upon whether the customer is a residential or commercial customer? If so, how?
You will want to prepare a summary of your findings to present to the company's management. You will find and explain the regression model using a nontechnical discussion of your forecasting model.
Step by step method for computing multiple regression model s given in the answer.