Statistic assignment* Can you use annual revenues generated by European soccer teams to predict franchise values? (Must include all in Excel)

For the 'Annual Revenues' and the 'Franchise Values': (a) Construct Histograms for each. (b) Construct Boxplots for each. (c) Compute Summary Statistics for each. (d) Create a scatter plot for the 'Annual Revenues' and the 'Franchise Values'. (e) Assuming a linear relationship, compute the regression coefficients bo and by. (f) Interpret the meaning of the y intercept, bo and the slope, b1, in this problem. (g) Predict the mean value of a franchise that generates $150 million of annual revenue. (h) Compute the Coefficient of Determination, r?, for the 'Annual Revenues' and the 'Franchise Values' and interpret its meaning. (i) Perform a residual analysis on your results and evaluate the regression assumptions.