DELIVERABLE: A document (word). The work should be done in Excel but transferred to document for… 1 answer below »

DELIVERABLE: A document (word). The work should be done in Excel but transferred to document for submission. Specific requirements are here, excel file for which this should be done is attached: For each variable you need: -Full descriptive statistics -Histogram -A brief discussion of the histogram indicating if it looks like a normal distribution or not For each pairing of the dependent variable with an independent variable (so you have at least 10 pairs because you have one dependent variable and at least 10 independent variables) you need: -A scatter plot with a best fit liner trend line. -The best fitting non-linear trend line as provided by excel. -Both trend lines should include an equation and a value for r-square. -Finally, rank your variables by the strength of the prediction (r-square) that they make for your dependent variable.