COPE D Quizzes Modules H9 H A 1 Home 2 Suits 3 Bunglow 4 Condo A...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 Ans Home Build Year Square Foot Color of house Number of Rooms Family Size Price per Room Grand Total Suits 2012 1600 White 4 4 12000 Bunglow 2017 1200 Red 5 6 12500 Condo 2020 750 Bl... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
Explain how the Spanning Tree Protocol works and its impact on physical loops between bridges and switches. What kind of problems would logical loops pose for packets delivery? Also, how do you think...
-
Fix this program so that it prints out "Java" in a box formed with asterisks, like this: **** * * Java * * ******** * 1 public class FixMe 2 { 123456789BE 10 11} public static void main(String[]...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A specific purpose statement is not stated in the speech but includes both the general purpose and the topic. It often reveals the intended goal for the audience. O True False
-
Consider two identical 80-kg men who are eating identical meals and doing identical things except that one of them jogs for 30 min every day while the other watches TV. Determine the weight...
-
If all the links in the Internet were to provide reliable delivery service, would the TCP reliable delivery service be redundant? Why or why not?
-
The velocity ratio of first system of pulleys is _____.
-
Cool Sky reports the following costing data on its product for its first year of operations. Year, the company produced 44,000 units and sold 36,000 units at a price of $140 per unit. Manufacturing...
-
What is the overall impact of adding the hammer to Tenalpina's product lines? How many hammers must be sold to "keep the company profits the same?"In other words, not decrease profits. Is purchasing...
-
Acme Parts runs a small factory and employs workers who are paid one of three hourly rates depending on their shift: first shift, $17 per hour; second shift, $18.50 per hour; third shift, $22 per...
-
The patient who has sustained a high cervical level injury will require a tremendous amount of support/care from caregivers. Unfortunately, due to the demands placed on caregivers and the dependence...
-
On January 1 , 2 0 2 2 , Matrix, Inc. purchased as an investment $ 1 , 0 0 0 , 0 0 0 , of 1 0 % , 1 0 - year bonds in Chelsea Corp, interest paid semi - annually ( at 6 / 3 0 and 1 2 / 3 1 ) . The...
-
Assume that for the meals sold in a restaurant in a given period of time, there were perfect portions with no waste and no shrinkage of ingredients. What does this illustrate?
-
a) Describe in detail the All-event test to determine Income recognition for Accrual method taxpayer. When does an accrual taxpayer have to recognize an income in the scenario that the transaction...
-
How do socialization agents serve as conduits for the transmission of cultural norms and values within societal structures?
-
What is the Financial Services Guide? Discuss some services in the Guide for official sex procedure.
-
Identify the fat soluble vitamin: A) Thiamine B) Nicotinic acid C) Ascorbic acid D) Calciferol
-
If the cylinder described in Problem 21.3 were initially heated to 500F, how long would it take for the center of the cylinder to cool to 240F if it were constructed of a. Copper? b. Brass? c. Nickel?
-
The following additional information is available for the Dr. Ivan and Irene Incisor family. Ivan and Irene have the following investment income, in addition to that reported in Chapter 1: Dividends...
-
Ken (age 31) and Amy (age 28) Booth have brought you the following information regarding their income, expenses, and withholding for the year. They are unsure which of these items must be used to...
-
Frederick (Freddy) Freeweights (age 42) owns and operates a health club called ''Treadmills West.'' The business is located at 4321 Arnold Street, Alpine, CA 91901. Freddy had the following income...
-
A crystal sample of bacteriorhodpsin, a light-sensitive protein found in halobacteria that responds to light energy, has crystal planes separated by 0.20 nm. If a beam of 11 keV x rays illuminates a...
-
A nickel crystals work function is measured to be 5.22 eV at 25C. As the temperature increases by 300C, the work function drops by 50 meV. By how much does this shift the threshold wavelength for...
-
Investigators have created structures consisting of linear chains of ionized atoms on a smooth surface. Electrons are restricted to travel along the chain. The energy levels of the electrons match...
Study smarter with the SolutionInn App