Year 1 - # of telemedicine phone calls received.  The Telemedicine Center is open from 7am to 7pm, seven days a week, and telehealth nurses work the entire 12 hour shift.  You can assume a single call takes 15 minutes for a telemedicine nurse to handle.

Month	Average # of Telemedicine calls received per day for each month the center was open in year 1
Jan	37
Feb	28
Mar	42
Apr	48
May	63
Jun	71
Jul	75
Aug	74
Sep	88
Oct	93
Nov	95
Dec	102

• Using Excel, create a linear regression equation to model the number of calls per month.
• At the current rate of growth, how many telemedicine calls does the regression equation predict for June of year 2?
• Given your prediction for June of year 2, how many telemedicine nurses do you forecast will be needed per 12 hour shift to handle the load?

Submit your findings in a Word document and include the Excel spread sheet.