1. You work as the Manager of a large practice of physicians in Central Virginia. Your boss, Dr. Pennypincher, has promised you a 10% raise if you can perform the following tasks by the end of the day. You are given the following data regarding the average daily visits by Medicaid patients Avg Daily Visits - Month Medicaid January 150 February 200 March 150 April 300 Predict what Mays average daily visit for Medicaid Patients will be using the Naive Prediction method. A B. Predict what Mays average daily visit for Medicald Patients will be using Moving Average (2) period)? C Predict what Mays average daily visit for Medicaid Patients will be using Moving Average (4 period)? D. Because April was double what March was for Medicald visits, Dr. Pennypincher tells you should weight April double thrt of March. Use a two-period moving average to predict May's visits where the weight of April is double that of March E. Due to your experience, you know that a smoothing constant may need to be added to the predictions. From your experience, you select a smoothing constant of 0.285. Using all four months of data, what would you predict for May's Medicaid visits? F Dr. Pennypincher does not trust your analytical skills. He insists you use a smoothing constant of 1.0. Using all four months of data, what would you predict for May's Medicaid visits? G. Dr. Foolish, Dr. Pennypincher's Brother, directs you to change your smoothing constant. He insists you use a smoothing constant of 0.0. Using all four months of data, what would you predict for May's Medicaid visits? H. Your assistant, Ms. Data-Smart, advices you that you should really calculate a simple linear regression for these data points. Prepare a simple liner regression and give the prediction for May and the R of the linear regression. Based on the R,how confident are you in this prediction? You should use the data given in 1.A, the 4 months and associated data. 1. Your assistant, Ms. Data-Smart, advises you that you should really add a graph of this simple linear regression. Please show the graph you will show Dr. Foolish and Dr. Pennypincher. 1. (BONUS) - Dr. Penncypincher gives you the following data involving the revenue generated and profits from 5 physicians who work for him. He would like for you to predict the expected profit generated if a sixth physician was added who generated $20,000 a month in revenue. What would Rfor this equation. Based on the R?, how confident are you in this prediction? Al, you will need the following data to complete the bonus problem (1) on the open book mid toom exam Provider Revenue Profits $15.000.00 $1,500.00 Napoleon $30,000.00 $2.800.00 $9.000.00 $1,100.00 Pedro $19.000.00 $1,800.00 Deb $50,000.00 $4,500.00 Rico