COPE D Quizzes Modules H9 H A 1 Home 2 Suits 3 Bunglow 4 Condo A 5 Apartments C6 Town Home 7 Home 1 8 Home 2 9 Home 3 10 Home 4 11 Home 5 12 Home 6 13 Home 7 Please complete the following tasks: 1. Download the datafile for the assignment. You can access the file here & 2. Using the Assignment 1 data file, please complete answer the following questions: 14 Home 8 15 Home 9 16 Home 10 17 Home 11 X4) Sheet1 1. Using formulas, determine how many houses were constructed in given year. 2. Using your analysis, create a chart detailing houses built by year. You can choose the formatting of the chart. Save your chart as a separate worksheet 3. Using formulas, determine the average price of each colour of house. 4. Using your analysis, create a chart detailing house price by colour. You can choose the formatting of the chart. Save your chart as a separate worksheet 5. Using formulas, determine the average number of rooms in each house. 6. Using formulas, calculate the total cost for each house. 7. Using formulas, determine the average house price. 8. For each house, compare the price and the number of rooms to determine which house gives the best value. You should use formulas to complete the calculation. 9. Create a chart displaying your analysis. Save the chart as a separate worksheet. 3. Save your workbook using the file name: FCT-MGMT311-Your Name-Assignment 1.xls 4. Upload your file to canvas fx B C D E Build Year Square Foot Color of house Number of Rooms Family Size Price per room Grand Total 2012 1600 White 4 4 12000 2017 1200 Red 6 2020 750 Black 2020 2021 2020 2018 2019 2011 2014 2018 2013 2014 2018 2013 2016 600 White 900 White 1200 Red 1300 Blue 1300 Blue 1300 Red. 1400 Black 1400 Yellow 1300 Black 1200 White 1200 Blue 1200 White 1500 White 4 5 6 7 8 9 AAAAE99A 10 11 12 13 14 15 16 17 4 8 6 5 6 5 4 6 3 4 3 6 3 4 12500 13000 13500 14000 14500 15000 15500 16000 16500 17000 17500 18000 18500 19000 19500