Part C: Regression and Correlation Analysis
Use the dependent variable (labeled Y) and
one of the independent variables (labeled X1, X2, and X3) in the data file.
Select and use one independent variable throughout this analysis. Use Excel to
perform the regression and correlation analysis to answer the following.1. Generate a scatterplot for the specified dependent variable (Y) and
the selected independent variable (X), including the graph of the "best
fit" line. Interpret.2. Determ..