Question
In: Statistics and Probability
Problem 1: The following data is in the following of Table. Education Expenditure data, Assuming there...
Problem 1: The following data is in the following of Table. Education Expenditure data, Assuming there is unique variance in each region, using two stage approach weighted least square approach to estimate X1, X2 and X3 effect on Y.
（sas programming）
STATE Y X1 X2 X3 Region
ME 189 2828 351 508 1
NH 169 3259 346 564 1
VT 230 3072 348 322 1
MA 168 3835 335 846 1
RI 180 3549 327 871 1
CT 193 4256 341 774 1
NY 261 4151 326 856 1
NJ 214 3954 333 889 1
PA 201 3419 326 715 1
OH 172 3509 354 753 2
IN 194 3412 359 649 2
IL 189 3981 349 830 2
MI 233 3675 369 738 2
WI 209 3363 361 659 2
MN 262 3341 365 664 2
IA 234 3265 344 572 2
MO 177 3257 336 701 2
ND 177 2730 369 443 2
SD 187 2876 369 446 2
NB 148 3239 350 615 2
KS 196 3303 340 661 2
DE 248 3795 376 722 3
MD 247 3742 364 766 3
VA 180 3068 353 631 3
WV 149 2470 329 390 3
NC 155 2664 354 450 3
SC 149 2380 377 476 3
GA 156 2781 371 603 3
FL 191 3191 336 805 3
KY 140 2645 349 523 3
TN 137 2579 343 588 3
AL 112 2337 362 584 3
MS 130 2081 385 445 3
AR 134 2322 352 500 3
LA 162 2634 390 661 3
OK 135 2880 330 680 3
TX 155 3029 369 797 3
MT 238 2942 369 534 4
ID 170 2668 368 541 4
WY 238 3190 366 605 4
CO 192 3340 358 785 4
NM 227 2651 421 698 4
AZ 207 3027 387 796 4
UT 201 2790 412 804 4
NV 225 3957 385 809 4
WA 215 3688 342 726 4
OR 233 3317 333 671 4
CA 273 3968 348 909 4
AK 372 4146 440 484 4
HI 212 3513 383 831 4
Solutions
Expert Solution
The output is:
| Regression Statistics | ||||||||
| Multiple R | 0.826129 | |||||||
| R Square | 0.682488 | |||||||
| Adjusted R Square | 0.661781 | |||||||
| Standard Error | 26.97031 | |||||||
| Observations | 50 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 3 | 71922.59 | 23974.2 | 32.95886 | 1.59E-11 | |||
| Residual | 46 | 33460.29 | 727.3976 | |||||
| Total | 49 | 105382.9 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | -289.179 | 66.16956 | -4.37028 | 7.01E-05 | -422.372 | -155.987 | -422.372 | -155.987 |
| X1 | 0.080886 | 0.009474 | 8.537784 | 4.83E-11 | 0.061816 | 0.099956 | 0.061816 | 0.099956 |
| X2 | 0.818411 | 0.161628 | 5.063534 | 7.1E-06 | 0.49307 | 1.143752 | 0.49307 | 1.143752 |
| X3 | -0.10377 | 0.035062 | -2.9595 | 0.004856 | -0.17434 | -0.03319 | -0.17434 | -0.03319 |
The least-square equation to estimate X1, X2 and X3 effect on Y using two-stage approach will be:
Y = -289.179 + 0.080886*X1 + 0.818411*X2 -0.10377*X3
orchestra answered 2 years agoRelated Solutions
Problem #1 1) Conduct a single-sample t-test for the following data set, assuming that µ =...
Problem #1
1) Conduct a single-sample t-test for the following data set,
assuming that µ = 25.00.
20 45 10 25 35 15 19 22 35 10 15 30
2) Determine the critical values (for an alpha of .05) that you
should use to evaluate this t-score.
In the file pubexp.dat there are data on public expenditure on education (EE), gross domestic product...
In the file pubexp.dat there are data on public expenditure on
education (EE), gross
domestic product (GDP), and population (P) for 34 countries in
the year 1980. It is
hypothesized that per capita expenditure on education is
linearly related to per capita
GDP. That is,
yi . b1 . b2xi . ei
where
yi . EEi
Pi
and xi . GDPi
Pi
It is suspected that ei may be heteroskedastic with a variance
related to xi.
(a) Why might the...
Problem 1 The following table lists data on the participation scores and midterm exam scores for...
Problem 1
The following table lists data on the participation scores and
midterm exam scores for 23 students who took the Accounting Theory
class in Spring 2019.
Student Number
Participation Score
Midterm Score
1
5
75
2
6.5
84
3
6.5
73
4
7
96
5
7.5
83
6
7.5
88
7
7.5
75
8
8
75
9
8.5
82.5
10
8.5
89
11
8.5
90
12
8.5
91
13
9
92
14
9
81.5
15
9
95
16
9...
Consider the data presented in the table: Actual aggregate expenditure or output (Y) (billions of $)...
Consider the data presented in the table:
Actual
aggregate expenditure or output (Y) (billions of $)
Consumption (C) (billions of $)
Planned investment (billions of $)
Government spending (G) (billions of $)
Net
exports (NX) (billions of $)
Unplanned investment (inventory change) (billions of
$)
470
270
130
80
30
570
350
670
430
770
510
870
590
Based on the assumptions of the aggregate expenditure model,
fill in the columns for planned investment, government spending,
and net exports.
Instructions:...
Consider the data presented in the table: Actual aggregate expenditure or output (Y) (billions of $)...
Consider the data presented in the table:
Actual aggregate expenditure or output (Y) (billions of
$)
Consumption (C) (billions of $)
Planned investment (billions of $)
Government spending (G) (billions of $)
Net exports (NX) (billions of $)
Unplanned investment (inventory change) (billions of
$)
Future output tendency (does it increase, decrease, or
stay the same?)
350
200
60
90
60
(Click to
select) increase decrease same
400
220
(Click to
select) increase decrease same
450
240
(Click to
select) increase decrease same
500
260
(Click to
select) increase decrease same
550...
Consider the data presented in the table: Actual aggregate expenditure or output (Y) (billions of $)...
Consider the data presented in the table:
Actual aggregate expenditure or output (Y) (billions of
$)
Consumption (C) (billions of $)
Planned investment (billions of $)
Government spending (G) (billions of $)
Net exports (NX) (billions of $)
Unplanned investment (inventory change) (billions of
$)
Future output tendency
430
230
130
90
40
(Click to
select) increase decrease same
530
300
(Click to
select) increase decrease same
630
370
(Click to
select) increase decrease same
730
440
(Click to
select) increase decrease same
830
510
(Click to
select) increase decrease same
a. What is the...
Refer to columns 1 and 6 in the table. Incorporate government into the table by assuming...
Refer to columns 1 and 6 in the table. Incorporate
government into the table by assuming that it plans to tax and
spend $20 billion at each possible level of GDP. Also assume that
the tax is a personal tax and that government spending does not
induce a shift in the private aggregate expenditures schedule. What
is the change in equilibrium GDP caused by the addition of
government?
(6)
Aggregates, Private Open Economy, Billions
(5)
Net Exports, Billions
(4)
Imports,...
1. Given the following table, answer the following questions (6 Marks) Personal consumption expenditure C 800...
1. Given the following table, answer the following questions Personal consumption expenditure C 800 Government
expenditure G 400 Taxes T 420 Export X 200 Import M 300 Gross
Domestic Product Y 1800 a. The value private saving is ________ b.
The value of public saving is ________ c. The value of national
saving is ________ d. What is the value of gross private investment
Ig? ________ e. What is the amount of investment financed by
national saving? ________ f. What...
Use the data in the table below to calculate Cp, Cpl, Cpu, and Cpk, assuming that...
Use the data in the table below to calculate Cp, Cpl, Cpu, and Cpk, assuming that the
specifications are 3.60 ± 1.30. Do not round intermediate
calculations. Round your answers to three decimal places.
Sample
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Observations
3.50
3.53
3.69
4.17
4.02
3.50
3.22
4.26
4.44
3.72
4.12
3.28
3.91
3.67
3.68
3.65
3.41
3.32
3.48
3.34
4.32
3.60
3.28
3.69
3.63
3.25
3.16
3.41
3.67...
Consider the data provided in the table below, which shows years of education and income for...
Consider the data provided in the table below, which shows years
of education and income for ten individuals.
Education
Income(1)
Income(2)
10
15,000
15
12
20,000
20
12
35,000
35
12
40,000
40
12
60,000
60
16
50,000
50
16
60,000
60
16
70,000
70
18
60,000
60
21
80,000
80
A) Calculate the covariance and correlation of education and
income, using the “Income1” column for income, which is measured in
dollars.
B) Calculate the covariance and correlation of education...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $4,532.35. The bonds...
- How do you represent 5.1 (5 + 1/10) in binary? I know that it is 0101....
- More and more adults are considering commuting to work by bicycle rather than car, but few...
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
- Write a function file that accepts each of the four vectors as inputs. The function file...
- Kant says that to act morally is to act out of duty. How does this differ...
- Suppose you are trying to determine the capacity (in gallons) of the gas tank needed on...
ADVERTISEMENT