In what follows use any of the following tests/procedures: Regression, multiple regression, confidence intervals, one sided T-test or two sided T-test. All the procedures should be done with 5% P-value or 95% confidence interval.Some answers are approximated, choose the most appropriate answer. Open Wages data. SETUP: Is it true that more educated people have higher wages? Given the data your job is to confirm or disprove this assertion.
I. What test/procedure did you perform? (6.66 points)
II. Statistical interpretation? (6.66 points)
III. Conclusion? (6.66 points)
EDUCATION: Number of years of education.SOUTH: Indicator variable for Southern Region (1=Person lives in SEX: Indicator variable for sex (1=Female 0=Male).EXPERIENCE: Number of years of work experience.UNION: Indicator variable for union membership (1=Union member AGE: Age (years).RACE: Race (1=Other 2=Hispanic 3=White).WAGE: Wage (dollars per hour).OCCUPATION: Occupational category (1=Management SECTOR: Sector (0=Other 1=Manufacturing 2=Construction).MARR: Marital Status (0=Unmarried 1=Married)
8012103525.1611
9014205734.95611
1200101936.67610
1200402234600
12001703537.5601
13009128313.07600
10102704334.45600
12009027319.47600
160011033313.28611
1200902738.75600
120017135311.35601
120019137311.5610
8102704136.5601
9103014536.25600
91029044319.98601
12003705537.3621
7104405738601
120026144322.2611
11001603333.65600
120033051320.55601
12011613435.71611
7004215517611
1200902733.75600
11101403114.5601
12002304139.56601
6104505735.75611
1200802639.36611
10003004636.5601
1201802633.35611
1200802634.75601
14001303338.9600
12114606434600
8001903334.7601
1711102435600
12001903739.25610
120036054110.67600
12102003817.61621
120035153110621
1200302137.5600
141010030312.2611
1200001833.35600
141014134311611
120014032312611
9011603134.85611
1310802734.3620
7111502836611
160012034315611
10101302934.85600
8003314739601
1200902736.36611
1200702539.15601
160013135311611
1201702534.5611
12011603434.8611
1300001934600
12011102935.5610
13001703638.4610
10001302936.75611
120022140110610
12012804635611
11001703436.5600
120024142310.75621
3105506427611
12103021311.43620
1200612414610
10002704339621
121019137113611
120019137312.22621
12013805636.28611
10104115716.75611
1110302013.35610
140020140316601
10001503135.25601
810802223.5611
8113905334.22611
6014315523611
11112514234611
120011129310601
12001203015601
121035153316611
140014034313.98600
120016134313.26601
10014416036.1610
16111303533.75600
1300812719610
12001303139.45610
11001813535.5601
12011803638.93601
1211602436.25600
11103715439.75611
1210202036.73611
12002304137.78611
1200101932.85600
12111002813.35611
120023041319.98611
1200812618.5601
1501903039.75611
120033151315621
12011903738611
130014033311.25601
110013130314601
100012028310621
1200802636.5600
12002304139.83611
140113033318.5610
12109027312.5601
140021141326601
51044055314621
12004122310.5601
80042056311611
130010129312.47601
120011029312.5620
120040158315621
1200802636620
11102904639.5621
1600312535600
11001102833.75620
120012130312.57601
8012203626.88601
12001203035.5601
1200712537601
12011503334.5610
12002804636.5601
121020138312611
1210602435620
1210502336.5610
9113004536.8611
13001803738.75601
1211602413.75611
12101603424.5600
1210111926600
1200302135.5610
12008026313601
1400202235.65610
9001603114.8610
1010902537621
1200202035.25600
7104305633.35611
9003805338.5611
1200902736601
12101203036.75601
12001803638.89611
110015132314.21610
111028145110.78621
10102714338.9621
12103805637.5601
1201302134.5610
120041159311.25601
121016134313.45601
1310702636611
6113304514.62610
140025045310.58611
1210502335601
14101703718.2600
1210101936.25600
12001303138.5611
160018040324.98101
141021041316.65101
1400202236.25100
1211402224.55100
121130048211.25101
130032051321.25100
170113036312.65101
12001703537.5100
140126046310.25101
1600903133.35100
16008030113.45100
1500112234.84101
171032055326.29101
12012404236.58101
14011021344.5100
120042060315111
16013025111.25110
12013205037101
140022042110100
160018040314.53101
180119043320101
150012033322.5101
12014206033.64101
121034052310.62101
180029053324.98101
1610803036100
180013037319110
160010032313.2100
160022044322.5101
161010032315101
17011503836.88101
120026044311.84101
140016036316.14100
180114038313.95101
120138056313.16101
12101403215.3101
1201702534.5101
181113037310100
100020036310101
16007129210101
16012604839.37101
16001403635.8101
130036055317.86100
12002404231101
14104106138.8101
1600702919101
171014037318.16100
1211101937.81100
16016028310.62111
1201302134.5101
150031052317.25101
130114033310.5111
14011303339.22101
160026148115111
180014038322.5101
13013305234.55201
12001603439201
180010034313.33201
140022042315200
1400202237.5200
12112904734.25201
120043061312.5211
1201502335.13201
16111403613.35201
121028046311.11201
11112504213.84201
12014506336.4201
1410502535.56200
121020038310211
1601602835.65201
160016038311.5201
11013305033.5201
1311202133.35201
12111002834.75200
141044064319.98201
1411602633.5201
12011503334200
1200502337201
1301402336.25211
14001403434.5201
140132052314.29201
12011403235201
140021041313.75201
120043161313.71201
12112704517.5201
1201402233.8200
1400002025200
12103205039.42201
12002003835.5201
1510402533.75200
12003405233.5201
1300502435.8200
170013036312211
14011703725301
13111002938.75301
16017029310301
12012504338.5300
12011803618.63301
16012704939311
1601202435.5300
130013032311.11301
140124044310300
18111303725.2301
14011513538300
12111203023.56300
12012404235.2301
120143061311.67321
120113031311.32311
12111603437.5301
11012404135.5301
1611402635301
12012404237.75301
12014506335.25301
12002013839301
12013805639.65301
18101003435.21301
11011603317301
121132050112.16301
1611202435.25300
131128047310.32300
1600302513.35300
1301812737.7300
12014406239.17311
12101203038.43301
1210802614301
1201402234.13301
12112804633301
1311001934.25300
1410102137.53300
140112032310.53311
12013905735301
120124042315.03301
170132055111.25301
1600402616.25300
12012504313.5300
1200802616.85300
130116035312.5301
12105023312300
13003105036300
12012504339.5300
12011503334.1301
141115035310.43301
1201001835300
12001903737.69301
12012103915.5300
1201602436.4300
120114132312.5301
13013004936.25301
1201802638300
9003314839.6300
13001603529.1300
12112003837.5300
1311602535301
12011012837301
1311102033.55300
1210202018.5300
1311001934.5300
16001703917.88301
1201802635.25300
1210402235300
12011503339.33300
120129047310.5301
12112304117.5301
12113905739.5301
12111403239.6301
1711602915.87300
141012132311.02301
12112604435300
14013205235.62301
15016027312.5301
120140058310.81301
12011803635.4311
11011202937300
12113605434.59321
12011903736301
160142064311.71310
1301202125.62301
12013305135.5301
12111403234.85301
12002204036.75300
12012003834.25301
12011503335.75301
12003505333.5301
1201702533.35301
120145063310.62310
1201902738300
1211202034.75301
1710302638.5300
14011913918.85301
12111403238301
4005406436401
14001703737.14401
8012904313.4401
15112604736400
2001602423.75400
8012904318.89400
11012003734.35401
101138054113.1401
8113705114.35401
9004806333.5400
12011603433.8400
8013805235.26401
1400002013.35400
120014132116.26400
1201202034.25401
16002104334.5401
13011503438401
16012004234400
14011203237.96401
1210702524400
1100402134.15401
1310902835.95401
12114306123.6401
10101903538.75400
8014906333.4400
12013805634.28401
12011303135.35401
12011403235401
12002003837.65400
1201702536.94400
1201912737.5411
1201602433.6400
1211502331.75401
1311102013.45400
14002214239.63401
12012404238.49401
12011513338.99400
1111802533.65401
11111703433.5401
1210202013.43400
12102003835.5401
12002614436.93401
10113705313.51401
12014105933.75400
12012704534.17401
1201512339.57401
140016036114.67401
140119039312.5401
12001002835.5401
1310112035.15400
12014316118401
1300302215.83400
1201001833.35400
12112604437401
100125141310401
12011503338401
14111003036.88400
11014516235.55400
1100302017.5400
8004716128.93401
1601602819401
10113304933.5400
1600302535.77410
14004124225400
14003415416.85401
11103905636.5401
12111703533.75401
9004716233.5401
1100201934.5400
1310001932.01400
14012404434.17400
120025143113401
1401602633.98400
12011002837.5400
120133051113.12401
12001203034400
1211902733.95401
111018135313401
12001002839401
8114505934.55400
9014616139.5401
7101402724.5401
11013605338.75400
130034153310521
180015039318501
170031054324.98511
16016028312.05510
141015035322501
12003004838.75501
18008032322.2501
18005029317.25511
1701312636500
13101703638.06501
1600512719.24511
140110030312501
150133054310.61500
1800302735.71501
16010018310500
161013035117.5501
180012036315501
1601602837.78501
1700703037.8501
161014136310501
17015028324.98500
151110031310.28501
180111035315501
170124047312501
16009031310.58510
18101203635.85501
180019043311.22501
14011403438.56501
160117039313.89510
1810703135.71500
18007031315.79501
16012204437.5501
120128046311.25501
16011603836.15500
161016038113.45500
1601702936.25501
12011102936.5500
120111029312501
12011603438.5500
18003315738500
12112103935.75501
16004026315.73511
15001303439.86501
180014138313.51501
16011003235.4501
18101403836.25501
16102905135.5501
1200402225500
18002705116.25501
1200302135.75501
161014136320.5501
1400002035521
18003305737501
161038060318501
180118142312501
17003026320.4510
180140064322.2500
140019039316.42510
1401402438.63500
160111033319.38501
160116038314501
140022042310501
170113136315.95500
161128150320501
160110032310501
16115027324.98500
15005026311.25500
180137061322.83510
170126149310.2501
16114026310501
180131155314500
170113136312.5501
12014206035.79501
170018041224.98501
1201302134.35501
170110033311.25500
16011013236.67500
16011703928501
18007031318.16501
160114036312501
16012214438.89501
17011403739.5501
160011033313.65501
180023147312501
120039157315501
160015037312.67501
14011503527.38500
160010032315.56500
12112504337.45500
14011203236.25501
1611702926.25501
1700713039.37501
160017039322.5511
16001013237.5501
1710202537501
9113414915.75501
15011103237.67501
150010031312.5500
121012030316501
16016128311.79500
18005029311.36500
12013305116.1501
170125148123.25501
121013131319.88501
160033055315.38511
I)
Ans a. Ones-sided t-test.
Since it is right-tail test [ Null hypothesis H0: average mpg=3500 vs alternative hypothesis H1:average mpg>3500]
II)
Test of mu = 3500 vs > 3500
95% Lower
Variable N Mean Std.Dev SE Mean Bound T P
Cadillac 11 3984.0 300.2 90.5 3819.9 5.35
0.000
Due to small margin of error we are confident that the average mpg is above 3500.
Since p-value=0.000<0.05, we conclude that the average mpg is above 3500.
III).
a. Yes, we can confirm the assertion. [Since p-value = 0.000<0.05]
Get Answers For Free
Most questions answered within 1 hours.