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)
the following information for various houses Home type Build year Square footage Color Number of rooms Family size Price per room Grand total To calculate the average price of each house coloryou can ... 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
-
How does pressure at the bottom of a body of water relate to the weight of water above each square meter of the bottom surface?
-
Banks charge billions of dollars per year in overdraft, insufficient funds, or "bounced" check fees. As a group project, survey several local financial institutions to determine their fees and...
-
Listed below are ten separate situations. For each item indicates whether the difference is (1) temporary creating a deferred tax asset or a deferred tax liability or (2) permanent. Item 1. Pension...
-
The following data were obtained from a study of the times required to conduct a consumer test panel study: Costs are given in thousands of dollars, time in weeks. (a) Find the all-normal schedule...
-
need help on this Question 15 (1 point) A firm's cost of financing, in an overall sense, is equal to its: (A) yield from various kinds of marketable securities. O B) rate of return from various kinds...
-
John has created an incredibly successful wine operation in the Northeast. All 5 are in a separate S-Corporation with all the stock owned by the parent Company Petosa Vineyards Inc, also an...
-
Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for $110 per unit. Variable expenses are $77 per stove, and fixed expenses associated with...
-
Mary Smith has just reported for duty and is reviewing the patients she will have during the evening shift. One of them, Ida Monroe, is on isolation for an infectious disease. Dr. Jerome comes into...
-
Suppose you have a Cellular loT system with the following parameters: An eNB with EIRP power of 42 dBm. The receiver is an loT device with effective bandwidth of BW= 180 kHz and requires a minimum...
-
Your task for this part of the case is to conduct a comprehensive financial analysis of Royal Caribbean Cruises and to compare their performance with Carnival Cruises. Excerpts from Royal Caribbean's...
-
A non-dividend-paying stock is currently traded at $50 and the one-month simple risk-free interest rate is 1%. Based on the Black-Scholes-Merton model, a one-month European call on this stock with...
-
On January 1, 2024, the Excel Delivery Company purchased a delivery van for $33,300. At the end of its five-year service life, it is estimated that the van will be worth $3,000. During the five-year...
-
As a business owner who runs an importing business for clothing, how do you intend to manage your inventory? Your response should include how you intend to determine the quantity to order, when to...
-
Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation...
-
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...
-
Find a Fourier series representation of the Dirac delta function, \(\delta(x)\), on \([-L, L]\).
-
Use the result from Problem 6 plus properties of the Fourier transform to find the Fourier transform, of \(f(x)=x^{2} e^{-a|x|}\) for \(a>0\). Data from Problem 6 For \(a>0\), find the Fourier...
-
A damped harmonic oscillator is given by \[f(t)=\left\{\begin{array}{cc} A e^{-\alpha t} e^{i \omega_{0} t}, & t \geq 0 \\ 0, & t <0 \end{array} ight.\] a. Find \(\hat{f}(\omega)\) and b. the...
Study smarter with the SolutionInn App