The first practice exercise reinforces basic data analysis skills using Excel pivot tables and charts. The practice exercises are required and graded for completion only. Together they count for 10% of the course grade, and all parts of the exercise must be fully complete to receive credit. The solution file will be available for review the day after it is due. To get started, download the attached instruction sheet and data file. Your submission should be a single Excel file with (4) labeled worksheets.
Overview: For this exercise, you will analyze a dataset of home sales in the role of a real estate analyst working for Big Sky Real Estate Company which specializes in mountain ski resort properties in Bozeman, Montana. The dataset includes homes listed and sold in the second quarter of 2023, and you have been asked to identify trends in the market. Follow the attached instructions to analyze the data and create pivot tables and a sales trends chart. Prepare your analysis as though you were presenting it to the real estate firm’s management team (e.g., professional formatting, titles, correct number formatting, etc.).