This Excel Project Asks You To Use the Skills Youve Learned

This Excel Project Asks You To Use the Skills Youve Learned In Excel This Excel project asks you to use the skills you've learned in Excel I, Excel II, and Excel comprehensive practice to answer the following question. For this project, you will need the following files: No41, 51, 61, 71.txt, which contains quarterly revenue data for company XYZ, and Main file.xlsx, which contains macro-economic variables including disposable income in billions of dollars, unemployment rate in percentage, and workforce population in thousands. Data in these files differ from those used in previous data analysis projects. Only these two files should be used. Import the company revenue data from the files No41.txt, No51.txt, No61.txt, and No71.txt into a new worksheet within Main file.xlsx. Rename this worksheet to “Company revenue.” On this worksheet, insert a new column to the right of the first column and label the header in cell B1 as “Quarter.” Using formulas, fill in the “Quarter” column such that if the month of the date is March (3), the value is “1”; if June (6), then “2”; September (9), then “3”; and December (12), then “4.” This step involves combining data from the four imported datasets into a single comprehensive table. Use Excel functions (such as VLOOKUP, INDEX/MATCH, or other appropriate functions) to bring in the variables Disposable Income, Unemployment Rate, and Population from their respective worksheets into this comprehensive data worksheet. Ensure these are matched accurately based on corresponding dates, noting that dates across worksheets differ and some revenue data may be missing intentionally. Once the comprehensive dataset is assembled, clean the data by deleting rows containing invalid entries indicated by ‘#N/A’—first for revenue, then for unemployment rate, by sorting accordingly to cluster these invalid data at the bottom, and then removing them. After cleaning, sort the entire dataset in ascending order by date. Next, in column G, label cell G1 as “Income growth.” Starting from G3, calculate the growth rate of Disposable Income using the formula: (Current period income - Previous period income) / Previous period income. Paste the results as values so that the data are stored as numbers, not formulas, and format the figures to show as percentages with two decimal places. In cell H2, calculate the average disposable income growth rate using an appropriate formula (such as AVERAGE on the values in column G). Ensure the first column (dates) is always visible by freezing the first column for ease of navigation. Then, perform a formal multiple linear regression with Revenue as the dependent variable and Unemployment Rate and Population as independent variables. Generate the