Download and complete the attached workbooks begin with Step 1 (with 4 worksheets).
Sans the data worksheet, each of the 3 worksheets has a yellow instruction block at the top. Follow the instructions to develop the contents of your worksheet.
Lab Objective:A. Further develop (or review) Excel skills in spreadsheet programming and selection of functions.B. Link results to interpretation.C. Visualization of the descriptive statistics numerics.D. Introduction to the use of the Data Analysis plugin tools.E. Introduction to the use of PIVOT tables, interpretation of results, and demonstrating the consistency of the results with regards to the above.
Once done with step 1 answer the questions 1-15 in step 2.