- Obtain the appropriate measure of dispersion for age and both income variables.
DATA
Subject |
Gender |
Marital Status |
Age |
Education |
Household Income |
Personal Income |
1 |
F |
1 |
30 |
0 |
70000.00 |
40000.00 |
2 |
F |
0 |
40 |
0 |
32500.00 |
32500.00 |
3 |
M |
1 |
45 |
0 |
42000.00 |
.0 |
4 |
M |
1 |
23 |
0 |
50000.00 |
50000.00 |
5 |
M |
0 |
50 |
0 |
4500.00 |
4500.00 |
6 |
F |
0 |
65 |
1 |
40000.00 |
22000.00 |
7 |
F |
1 |
33 |
1 |
12000.00 |
12000.00 |
8 |
F |
0 |
20 |
2 |
56000.00 |
52000.00 |
9 |
F |
missing |
30 |
3 |
17500.00 |
17500.00 |
10 |
M |
1 |
Missing |
4 |
44000.00 |
39000.00 |
11 |
M |
2 |
58 |
1 |
missing |
missing |
12 |
M |
2 |
32 |
2 |
10000.00 |
10000.00 |
13 |
M |
1 |
35 |
3 |
missing |
missing |
14 |
F |
2 |
23 |
4 |
100000.00 |
50000.00 |
15 |
F |
2 |
34 |
1 |
64000.00 |
64000.00 |
16 |
M |
1 |
26 |
2 |
Missing |
missing |
17 |
M |
1 |
36 |
3 |
missing |
missing |
18 |
F |
0 |
41 |
4 |
7500.00 |
5500.00 |
19 |
F |
0 |
43 |
1 |
missing |
missing |
20 |
F |
1 |
46 |
2 |
100000.00 |
missing |
21 |
F |
1 |
18 |
3 |
24000.00 |
24000.00 |
22 |
F |
1 |
40 |
4 |
42000.00 |
22000.00 |
23 |
M |
2 |
19 |
1 |
missing |
missing |
24 |
M |
2 |
23 |
2 |
missing |
missing |
25 |
M |
2 |
24 |
3 |
3500.00 |
3500.00 |
26 |
F |
1 |
55 |
4 |
45000.00 |
22500.00 |
27 |
M |
1 |
52 |
1 |
350000.00 |
.0 |
28 |
M |
1 |
34 |
2 |
5000.00 |
5000.00 |
29 |
F |
0 |
35 |
3 |
10000.00 |
310400.00 |
30 |
M |
0 |
61 |
4 |
55000.00 |
42000.00 |
31 |
F |
0 |
63 |
1 |
25000.00 |
25000.00 |
32 |
M |
1 |
66 |
2 |
22000.00 |
22000.00 |
33 |
M |
1 |
42 |
3 |
40000.00 |
40000.00 |
34 |
M |
missing |
47 |
4 |
40000.00 |
40000.00 |
35 |
F |
1 |
48 |
missing |
missing |
missing |
36 |
F |
2 |
45 |
0 |
18000.00 |
18000.00 |
37 |
M |
2 |
34 |
0 |
50000.00 |
50000.00 |
38 |
M |
0 |
65 |
0 |
200000.00 |
missing |
39 |
M |
1 |
58 |
1 |
50000.00 |
.0 |
40 |
F |
1 |
missing |
2 |
missing |
missing |
41 |
F |
0 |
19 |
1 |
3500.00 |
2000.00 |
42 |
F |
0 |
22 |
1 |
55000.00 |
35000.00 |
43 |
F |
0 |
30 |
1 |
60000.00 |
40000.00 |
44 |
F |
0 |
35 |
1 |
300000.00 |
150000.00 |
45 |
F |
1 |
40 |
4 |
800000.00 |
600000.00 |
46 |
F |
1 |
42 |
4 |
3600.00 |
2000.00 |
47 |
F |
1 |
48 |
4 |
333000.00 |
153000.00 |
48 |
M |
1 |
50 |
3 |
4500.00 |
2500.00 |
49 |
F |
1 |
55 |
2 |
56000.00 |
36000.00 |
50 |
M |
0 |
47 |
1 |
55000.00 |
35000.00 |
51 |
M |
1 |
45 |
0 |
100000.00 |
50000.00 |
52 |
M |
missing |
33 |
0 |
60000.00 |
35000.00 |
53 |
F |
1 |
25 |
1 |
505000.00 |
350000.00 |
54 |
M |
0 |
68 |
2 |
4200.00 |
2200.00 |
55 |
F |
0 |
72 |
2 |
missing |
.0 |
56 |
F |
1 |
68 |
3 |
31000.00 |
20000.00 |
57 |
M |
1 |
33 |
4 |
250.00 |
150.00 |
58 |
M |
1 |
35 |
missing |
45000.00 |
30000.00 |
59 |
F |
1 |
56 |
3 |
25000.00 |
15000.00 |
60 |
F |
0 |
65 |
3 |
23000.00 |
20000.00 |
**Note : Gender (0=female, male=1); Marital Status(0=unmarried, 1=married, 2=widowed), Age (in years); Education (0= less than high school, 1=high school, 2=college, 3=postgraduate, 4=professional degree); Missing (missing = -9)
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 3 images
- A survey is conducted on 700 Californians older than 30 years of age. The study wants to obtain inference on the relationship between years of education and yearly income in dollars. The response variable is income in dollars and the explanatory variable is years of education. A simple linear regression model is fit, and the output from R is below: Im(formula = Income ~ Education, data = CA) Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 25200.25 1488.94 16.93 3.08e-10 *** Education 2905.35 112.61 25.80 1.49e-12 *** Residual standard error: 32400 on 698 degrees of freedom Multiple R-squared: 0.7602arrow_forwardWalmart predicted the following end-of-year earnings from 2003 - 2012 in billions of dollars (9.5, 9.8, 10.2, 10.7, 10.5, 11.0, 12.1, 14.7, 16.3, 18.7). Their actual end-of- year earnings for the same years are as follows: 9.1, 9.2, 10.6, 10.3, 9.9, 10.4, 11.6, 11.8, 13.1, 22.7). In testing the claim that the mean predicted value is the same as the mean actual value, which p-value is correct? 0.228 0.456 0.779 0.05 4arrow_forwardBelow are listed several variables. Check ALL those that are QUANTITATIVE. Group of answer choices • The net profit for a company in 2000 • The dollar amounts on an accounts receivable invoice • The advertising medium (radio, tv, print) used to promote a product • The stock exchange (NASDAQ, NYSE, etc) on which a company’s stock is traded • The reason for termination for all ex-employeesarrow_forward
- or each predictor variable, state the P-value and determine whether the predictor variable is significant in explaining delivery charges. Predictor variables P-value Significant in explain Delivery charges Distance .................. .............. Weight .................. .............. Boxes ............... .................arrow_forwardThe following table shows a data set containing information for 45 mutual funds that are part of the Morningstar Funds 500 for 2008. . The data set includes the following five variables: Use Excel to answer the following question: a. Prepare a crosstabulation of the data on Fund Type (row variable) and the average annual return over the past 5 years (column variable). Use classes of 0–10, 10–20, 20–30, 30–40, 40–50, and 50–60 for the 5-Year Average Return (%) (Class width is 10). B. Construct frequency distributions for Fund Type and 5-Year Average Return (%) respectively. Based on the frequency distributions of the two variables, which of the following answers is wrong? Group of answer choices Out of the 45 mutual funds, there are 2 funds with 5-year average return of 30 - 40 (%). Out of the 45 mutual funds, there are 28 funds with 5-year average return of 10 - 20 (%). Out of the 45 mutual funds, there are 28 DE type of funds. Out of the 45 mutual funds, there are 10…arrow_forwardIn 2011 home prices and mortgage rates dropped so low that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent for 10 markets and the monthly mortgage on the median priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011).Click on the datafile logo to reference the data. Enter negative values as negative numbers. a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)arrow_forward
- The following table shows the total return and the number of funds for four categories of mutual funds. Excel File: data03-17.xlsx Type of Fund Number of Funds Total Return (%) Domestic Equity 9,191 4.65 International Equity 2,621 18.15 Specialty Stock 1,419 11.36 Hybrid 2,900 6.75 b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights? (i) Using "number of funds" as weights will only be a good approximation if the amount invested in various funds is approximately equal. The amount invested in each fund could be used for weights. (ii) Using "number of funds" as weights results in a good…arrow_forwardThe Bayside Fountain Hotel is adjacent to County Coliseum, a 24,000-seat arena that is home tothe city’s professional basketball and ice hockey teams and that hosts a variety of concerts, tradeshows, and conventions throughout the year. The hotel has experienced the following occupancyrates for the past 9 years, since the coliseum opened:Year Occupancy Rate (%)1 832 783 754 815 866 857 898 909 86 Compute an exponential smoothing forecast with a = .20, an adjusted exponential smoothingforecast with a = .20 and B=30 and a linear trend line forecast. Compare the three forecasts,using MAD and average error ( ), and indicate which seems to be most accurate.arrow_forwardA Midwest college admissions committee recently conducted a study to determine the relative debt incurred by students receiving their degrees in four years versus those taking more than four years. Some on the committee speculated a four-year student would likely be attending full time, whereas one taking more than four years could have a part-time job. However, average total debt provides only part of the information. Since the average, or mean, is affected by both large and small values, the committee also needed some way to determine the relative variances for the two groups. Samples of size 20 produced standard deviations of 2,636 for four-year graduates and 1,513 for those taking more than four years. Conduct a test of hypothesis to determine if the standard deviation of the debt for four-year graduates is larger than those taking more than four years. Use a significance level of 0.05.arrow_forward
- Please explain properlyarrow_forwardClassify the following studies as either descriptive or inferential and explain your answers. TV Viewing Times. Data from a sample of Americans yielded the following estimates of average TV viewing time per month for all Americans 2 years old and older. The times are in hours andminutes; Q1 stands for first quarter. [SOURCE: The Cross-Platform Report, Quarter 1, 2011. Published by The Nielsen Company, _c 2011.]arrow_forwardTYPEWRITTEN ONLY PLEASE FOR UPVOTE. DOWNVOTE FOR HANDWRITTEN. DO NOT ANSWER IF YOU ALREADY ANSWERED THIS. I'LL DOWNVOTE.arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning