Use the attached Excel Spreadsheet template to complete a regression analysis tracking Regular Gas Prices (the dependent variable) as affected by Crude Oil prices (the independent variable). Instructions for the three Tasks are included in the attached file. Use the naming convention SmityQ6FinalExam
First, open the workbook you downloaded from Step 1. Next, save your workbook as Week2_Lab_YourLastName_YourFirstName.xlsx. The data contains the following
First, open the workbook you downloaded from Step 1. Next, save your workbook as Week2_Lab_YourLastName_YourFirstName.xlsx. The data contains the following columns. Units A, B, and C Months Years Step 3: Create Format and Formulas Format the data for currency where needed. Add a title to the data worksheet. Make it