Use data and provide a scattered graph in excel. (Add treadline)Provide an explanation of questions 1-3.Note: For question #2 provide inputs of the given data using the linear equations y=mx+b

Effects of Sunlight Analysis In her initial observations, Dr. Zobb notices that the number of lesions that appear on a patient seems to be dependent on the amount of direct sunlight exposure that the patient receives. She is uncertain at this point why this would be the case, but she is a good experimentalist and is trying to establish some observations that have statistical validity. She has taken a limited amount of data on 8 patients and wants you to complete the appropriate analysis based on the data below (be sure to show your work): 1. Develop an equation to model the data using a regression analysis approach and explain your calculation process, using Excel. 2. Megan has a small group of three additional patients that are the same age that she wants to examine for lesions. She knows the number of hours of continuous exposure to direct sunlight that each has experienced. Predict the number of lesions that each of these patients will have based on the regression analysis that you completed in your initial data analysis: Patient 9 - 193 hours. o Patient 10 - 219 hours. o Patient 11 - 84 hours. 3. Determine three conclusions based on the correlation of the number of lesions to hours of sunlight exposure, using regression analysis. Sunlight Exposure Regression Data Time of Patient Continuous Number Exposure to Number of Direct Sunlight Lesions (Minutes) 1 225 24 2 184 16 3 220 20 4 240 26 5 180 14 6 184 16 7 186 20 Sunlight Exposure versus Lesions 8 215 22 Over the Coun