[Solved] data analysis

Assignment Prompt & Instructions

Individual Final Project Guidelines
## Project Description
• The final project accounts for 40% of the overall grade.
• Students are required to prepare 5 Excel files.
• Each file should replicate the same calculations and procedures demonstrated by the professor in the example Excel files.
## Reference Sessions
• The relevant materials and step-by-step explanations were provided during Q&A sessions 3, 4, 5, and 6.
• These sessions serve as the primary reference for completing the project.
## Evaluation Criteria
• Accuracy in reproducing the calculations.
• Proper structure and organization of the Excel files.
• Clarity and consistency of the results.
• Timely submission.
## Project Components
• The individual final project consists of a collection of 5 Excel files that must besubmitted.
• Each file will be opened at the beginning of the corresponding Q&A session, where the professor will explain in detail how to solve the exercise.
• All files with the worksheets will be available in the Worksheet section of the VirtualCampus.
• Each file includes:
o One fully solved exercise, which will be explained by the professor during the online Q&A session.
o One dataset for students to use in their project work.
• The student’s task is to reproduce all calculations performed by the professor but using the new dataset provided.
• Students must create their own worksheets until completing the same number of sheets as the professor’s original file.
## Final Grade
  The final grade for the project will be the average grade of the four submitted files.
\
001INDIVIDUALFINALPROJECTOUTLINEGUIDELINES.docx](https://www.sweetstudy.com/files/001individualfinalprojectoutlineguidelines-docx "001INDIVIDUALFINALPROJECTOUTLINEGUIDELINES.docx")
\
UNIT01INTROPIVOTTABLESPROJECT.xlsx](https://www.sweetstudy.com/files/unit01intropivottablesproject-xlsx "UNIT01INTROPIVOTTABLESPROJECT.xlsx")
\
UNIT022FREQUENCIESPROJECT.xlsx](https://www.sweetstudy.com/files/unit022frequenciesproject-xlsx "UNIT022FREQUENCIESPROJECT.xlsx")
\
UNIT052CORRELATIONPROJECT.xlsx](https://www.sweetstudy.com/files/unit052correlationproject-xlsx "UNIT052CORRELATIONPROJECT.xlsx")
\
UNIT032MEASURESPROJECT.xlsx](https://www.sweetstudy.com/files/unit032measuresproject-xlsx "UNIT032MEASURESPROJECT.xlsx")
\
UNIT042PROBABILITYPROJECT.xlsx](https://www.sweetstudy.com/files/unit042probabilityproject-xlsx "UNIT042PROBABILITYPROJECT.xlsx")