Question

In: Math

Use the data for two Sydney suburbs to answer questions 1-5:             1     Using Excel or other...

Use the data for two Sydney suburbs to answer questions 1-5:            

1     Using Excel or other appropriate software, produce two separate histograms for the median rental prices of the two selected suburbs, respectively.    

       Use an appropriate number of bins for your histogram and remember to label the axes. Describe and compare the two histograms, including the central location, dispersion and skewness. [1 mark]     

            

2     Compute the sample means and sample standard deviations of the median rental prices of the two selected suburbs, respectively. No need to show computational steps. [1 mark]   

Artarmon

 Chatswood
570 730
660 680
660 920
595 1100
500 880
610 840
600 750
600 540
600 490
590 630
690 600
625 600
610 1200
600 900
595 800
550 730
680 700
500 675
580 660
650 580
530 820
550 700
490 680
665 610
680 1200
580 900
680 880
670 870
585 850
660 800
500 800
595 790
490 780
530 780
565 750
570 750
580 750
595 720
600 720
600 700
610 680
625 660
660 650
680 650
690 650
580 610
585 600
650 595
665 580
590 580

Solutions

Expert Solution

Draw histogram in the first (1):

(2):

The calculation shown in the following table:

milcah answered 11 months ago
Next > < Previous

Related Solutions

Answer the two questions below in Excel using the WAAC Model. 1. You are considering a...
Answer the two questions below in Excel using the WAAC Model. 1. You are considering a pair of GICs (guaranteed investment contracts) o§ered by two di§erent life insurance companies. Each promises a single payment 10 years from now. (a) US Life Insurance Companyís GIC promises to pay 6.5% per annum and can be purchased today for $100,000. (b) Met Lifeís GIC promises to pay 5.7% per annum compounded monthly and can be purchased today for $95,000. Which would you buy?...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel,...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel, include the appropriate output (copy + paste) along with an explanation. Data description: An article in The Wall Street Journal (July 11, 2008) outlined a number of reasons as to why the 16 teams in Major League Baseball’s National League (NL) are inferior to the 14 teams in the American League (AL). One reason for the imbalance pointed to the disparity in opening-day payrolls:...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel,...
3. Use "MLB_Salaries" data in Chapter3.xlsx to answer the following questions. For questions that require Excel, include the appropriate output (copy + paste) along with an explanation. Data description: An article in The Wall Street Journal (July 11, 2008) outlined a number of reasons as to why the 16 teams in Major League Baseball’s National League (NL) are inferior to the 14 teams in the American League (AL). One reason for the imbalance pointed to the disparity in opening-day payrolls:...
Please answer the following questions using the data in the attached Excel file. You are thinking...
Please answer the following questions using the data in the attached Excel file. You are thinking of investing in Abercrombie and Fitch Co. (ANF). The returns for ANF are embedded in an Excel document below (Source: yahoo.com). 1.      For the investment in ANF that you are considering, for all of 2012 determine the following items: a) the mean return b) the median return c) the standard deviation d) the variance e) the coefficient of variation The weekly rates of return...
Answer the following questions using the data given in the table. Use the T-Test Paired Two...
Answer the following questions using the data given in the table. Use the T-Test Paired Two Sample for Means to arrive at the solutions to the questions below. Use an alpha value of 0.01 Home Appraiser 1 Appraiser 2 A $235,000 $228,000 B $210,000 $205,000 C $231,000 $219,000 D $242,000 $240,000 E $205,000 $198,000 F $230,000 $223,000 G $231,000 $227,000 H $210,000 $215,000 I $225,000 $222,000 J $249,000 $245,000 K $199,000 $201,000 1 What is the value for the test...
Using R Studio: 1)Use the `mtcars` data (`data(mtcars)`) to answer these questions: a) Which rows of...
Using R Studio: 1)Use the `mtcars` data (`data(mtcars)`) to answer these questions: a) Which rows of the data frame contain cars that weigh more than 4000 pounds (the variable is `wt`, units are 1000 pounds). b) Which cars are these? (*Hint:* since rows are named by car name, use `row.names()`). c) What is the mean displacement (in inches^3^ ) for cars with at least 200 horsepower (`hp`). d) Which car has the highest fuel economy (`mpg`)? e) What was the...
Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with...
Use SPSS, Excel or Minitab software to answer the following questions. Generate normal random data with sample size, n = 40, mean = 20 and standard deviation = 11. Write the generated data in the following table. Answer: 1 11 21 31 2 12 22 32 3 13 23 33 4 14 24 34 5 15 25 35 6 16 26 36 7 17 27 37 8 18 28 38 9 19 29 39 10 20 30 40 Conduct the...
Please use ONLY one Excel file to answer the below questions. ( including the formula using...
Please use ONLY one Excel file to answer the below questions. ( including the formula using for Excel) In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. In April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked to select the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chose gold as the best long-term investment. By contrast, only 91 chose bonds. Compute the...
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...
Create an Excel File to answer the following questions: 1. A bond has a 5% coupon...
Create an Excel File to answer the following questions: 1. A bond has a 5% coupon rate, and matures in 18 years, and has par value $1000. Find the price of the bond today if the yield to maturity is 4% first assuming annual payments, then again with semi-annual. 2. What is the yield to maturity on a semiannual bond with a 9% coupon rate, $1000 par value, and 3 years to maturity if the price of the bond today...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT