P. Use the provided Excel le. The first sheet is named as "Data". Do your calculations in the [11 sheet in this Excel le to answer this guestion. Do the following tasks: use the data in the "Data" table to calculate average and mean of every numerical column. Besides, calculate the linear correlation between each pair of columns. Report average of "Avg. Session Length", median of "Length of membership", and the pairs having the largest correlation, respectively. 33.05, 3.53, "Length of Membership" and "Yearly Amount Spent" 12115, 32.05, "Time on Website" and "Time on App 499.31, 3.53, "Time on Website" and "Avg. Session Length" 33.03, 3.53, "Time on App" and "Tea rly Amount Spent" 3. Use the data in the "Data" sheet and write your answers and calculations in sheet [12. Consider the "Yearly Amount Spent" column. Often outliers in a dataset can be dened as are ouEide the +E 35TD from the mean of the data. Use your knowledge on standardizing a distribution. Find the rows of data in the "Yearly Amount Spent" column that are considered to be "outliers". 1\"l'ou may highlight them in yellow. How many outlier did you nd?I I need to see your calculations in sheet [12. As well, write clown how many outliers you found below. 4. A farmer is trying out a planting technique that he hopes will increase the yield on his pea plant. The average number of pods on one of his pea planE is 145 pods with a standard deviation of l pods. This year, after trying his new planting technique, he takes a random sample of his plants and nds the average number of pods to be 14?. He wonders whether this is a statistically signicant increase. What are his hypotheses, the test statistic, and if we reject the HD or not? You need to use the {13 sheet in the Excel le, to clearly, and concisely, explain your decision-making process= Hi]: mu =c 145Ir H1: mu 2 145, 1 test = l].24, fail to reject Hi]: mu 3: 145Ir H1: mu c 145, 1 test = -.24, reject Hi]: mu =c 145Ir H1: mu 2 145, 1 test = l].24, reject Hi]: mu =c 145Ir H1: mu 2 145, 1 test = -.24, fail to reject 5. [in sheet {14, you will see two tables: payment, and customer. They belong to a DVD rental company. Each column in each table is easily understandable by its name. Write a query that returns rst name last name. and amount that each customer has paid. Order it from the largest payment amount to the smallest. Below, please only write down your query, no explanation