{b} Using the RACV Solar data set [which now includes transformed dummy variables) as your reference, complete the following steps: i. Correlation in the section marked "Correlation Table" {below the Conclusion section on the \"Correlation\" worksheet] generate a correlation table. Use the "Correlation\" option in Excel's Data Analysis ToolPak. ii. 0n the correlation table, identify and clearly indicate the Independent Variables which are [virtually] uncorrelated with the Dependent Variable [i.e., all IVs which have a correlation coefcient with the DV of between 4105 and 0.05}. These IVs are to be removed from the model prior to running the rst iteration of the regression model. iii. Complete the Uncorrelated Independent Variables summary table which is in the Conclusion section of the Correlation worksheet a summary of which Independent Variables have been eliminated from the regression model due to being {virtually} uncorrelated with System Cost [D'v']. iv. Multi-collinearity review the correlation table for instances of multicoiiinearity between Independent Variables ilVl. In cases of multicollinearity, identify and clearly indicate the IVs with the weakest correlation with the Dependent Variable. These IVs are to be removed from the model prior to running the first iteration of the regression model. v. Complete the MultiColiinearitysummary table which is in the Conclusion section of the Correlation worksheet a summary of which Independent Variables have been eliminated from the regression model due to mul'ticollinearity.