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 1 year agoRelated 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
ADVERTISEMENT
Latest Questions
- Explain why Agile Project Management (APM) may be better suited for managing software development projects as...
- Are there differences between on-line and "real-time" interactions and relationships?
- I need to take the code i already have and change it to have at least...
- Write a Bottle class. The Bottle will have one private int that represents the countable value...
- what are the advantages and disavdvages of Weighted average cost of capital?
- Suppose you bought a PUT option on a share of Tesla stock (Strike Price $200, Expiration...
- <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>All Pets Veterinary Hospital</title> <style> body { font-family: arial,...
ADVERTISEMENT