Answer all three parts correct with all steps with handwritten calculations only on page, do not use EXCEL. And must be correct solution or please don't attempt.

Case:

A local medical testing lab, has noticed that demand for its blood tests from walk-in customers has gone up over the last 16 weeks. It appears to have been caused by media hype around a diet, that involves people picking food based on their lipid profile.

The manager of the lap wants to forecast the # of walk-in arrivals for next week to better schedule resources. Data for the last 16 weeks of walk-ins for blood tests has been tabulated below. Data prior to that is not useful, as the current diet hype was not present before that.

A) Plot the data on an appropriate chart in Excel and visually inspect it for presence of a trend. What do you see:

		A positive trend
		A negative trend
		No trend
		Medical data should not be checked for trends, as that is relevant to consumer marketing data only.

B) Use regression to forecast the # of walk-in arrivals for week 17. Round your answer to the nearest integer.

C) What is the R2 (r squared) for the regression forecasting model?

Do not type in the % sign, and enter your answer to 2 decimal places on a scale of 0 to 100. E.g. R2 of 0.2314 will be entered as 23.14

D E A B i Medical Testing Lab, Walk-in Data 2 3 4 Week 5 1 Walk-in Arrivals 28 27 6 2 7 3 44 8 4 37 5 35 9 10 6 53 7 38 11 12 8 57 13 9 61 14 10 39 15 11 55 16 12 54 13 17 18 52 60 14 19 15 60 20 16 75 21 22