Conduct an analysis of your project data. Prepare the items below based on the data from two of the variables in the data collection instrument.Determine the mean, median, and mode for each of the variables.What is the variance for each set of data for each of the variables?What is the standard deviation for each of the variables?What is the probability that each event occurs in each of the two variables.Create an individual Excel document for each of the required items. Be sure to show your work.

Which best describes the correlation of the data.Positive correlationNegative correlationRelatively no correlationScattered correlation===============================Which best describes the correlation of the graph.Positive correlationNegative correlationRelatively no correlationScattered correlation=======================Which situation describes a negative correlation?The number of miles driven and the amount of gas used.The number of gallons of gas purchased and the amount paid for the gas.The size of a car’s gas tank and the number of gallons it holds.The number of miles driven and the amount of gas left in the gas tank.=====================Based on the line of best fit drawn below, which value could be expected for the data in June 2015?230310480540==================Which equation best models the data in the scatter plot?y=15=====================Using the scatter plot and line of best fit below, predict the average number of hours slept when 5 hours are spent watching TV.5 hours4 hours2 hours9 hours=====================Use the data below to draw a scatter plot. Then, decide which equation is the best approximation of the best-fitting line.y = -2x + 2.5y = 1.2x - 7.3y = -0.7x + 2.7y = -1.1x + 2.3=====================Which two points would be best to you use to find the equation of the best-fitting line shown on the scatter plot below?(0, 10.5) and (4.5, 6.5)(3.9, 9.5) and (8.7, 2.5)(0, 12) and (10.5, 0)(7, 4) and (0, 12)======================Which of the following shows the best approximation of a best fit line for the data below?======================A contractor recorded the amount of money earned for different jobs and the amount of time spent on each job. The data are shown in the scatterplot below. Based on the data, predict the amount of money the carpenter would earn from a job that took 15 days to complete.$1500$3000$3500$1000====================