sos
有个案例报告需要本周4前完成:题目如下,如何做呀?
根据以下数据,建立一个能估计一个在公路上驾驶汽车油耗;和在城市驾驶汽车油耗的估计的回归方程
其中:Class为:类型,Manufacturer:为汽车厂家, carline name为汽车名称,displ:发动机排量,cyl:发动机缸数, trans:变速箱类型, cty:在城市驾驶油耗(英里/加仑),hwy:在高速公路上驾驶油耗(英里/加仑)
抱歉不知如何附件EXCELL文件,数据只能copy如下:
---------------------------------------------
Class Manufacturer carline name displ cyl trans cty hwy
COMPACT CARS ACURA 3.2CL 3.2 6 Auto 20 29
COMPACT CARS ACURA 3.2CL 3.2 6 Manual 19 28
COMPACT CARS AUDI A4 1.8 4 Auto 23 29
COMPACT CARS AUDI A4 1.8 4 Manual 22 31
COMPACT CARS AUDI A4 3 6 Auto 20 28
COMPACT CARS AUDI A4 QUATTRO 1.8 4 Auto 20 28
COMPACT CARS AUDI A4 QUATTRO 1.8 4 Manual 21 29
COMPACT CARS AUDI A4 QUATTRO 3 6 Auto 18 26
COMPACT CARS AUDI A4 QUATTRO 3 6 Manual 18 25
COMPACT CARS BMW 325I 2.5 6 Auto 20 28
COMPACT CARS BMW 325I 2.5 6 Manual 20 29
COMPACT CARS BMW 325XI 2.5 6 Auto 19 26
COMPACT CARS BMW 325XI 2.5 6 Manual 19 27
COMPACT CARS BMW 330I 3 6 Auto 20 28
COMPACT CARS BMW 330I 3 6 Manual 21 30
COMPACT CARS BMW 330XI 3 6 Auto 18 25
COMPACT CARS BMW 330XI 3 6 Manual 20 27
COMPACT CARS BMW 525I 2.5 6 Auto 20 28
COMPACT CARS BMW 525I 2.5 6 Manual 20 29
COMPACT CARS BMW 530I 3 6 Auto 19 27
COMPACT CARS BMW 530I 3 6 Manual 21 30
COMPACT CARS BMW 540I 4.4 8 Auto 17 21
COMPACT CARS BMW 540I 4.4 8 Manual 15 23
COMPACT CARS BMW M5 4.9 8 Manual 13 21
COMPACT CARS CHEVROLET CAVALIER 2.2 4 Auto 24 33
COMPACT CARS CHEVROLET CAVALIER 2.2 4 Manual 26 33
COMPACT CARS CHRYSLER SEBRING 2.4 4 Auto 21 28
COMPACT CARS CHRYSLER SEBRING 2.4 4 Manual 24 32
COMPACT CARS CHRYSLER SEBRING 3 6 Auto 20 28
COMPACT CARS CHRYSLER SEBRING 3 6 Manual 21 29
COMPACT CARS CHRYSLER SEBRING CONVERTIBLE 2.4 4 Auto 22 30
COMPACT CARS CHRYSLER SEBRING CONVERTIBLE 2.7 6 Auto 21 28
COMPACT CARS CHRYSLER SEBRING CONVERTIBLE 2.7 6 Manual 20 27
COMPACT CARS DODGE NEON/SRT-4/SX 2.0 2 4 Auto 25 32
COMPACT CARS DODGE NEON/SRT-4/SX 2.0 2 4 Manual 29 36
COMPACT CARS DODGE STRATUS 2.4 4 Auto 21 28
COMPACT CARS DODGE STRATUS 2.4 4 Manual 24 32
COMPACT CARS DODGE STRATUS 3 6 Auto 20 28
COMPACT CARS DODGE STRATUS 3 6 Manual 21 29
COMPACT CARS FORD FOCUS 2.3 4 Auto 24 30
COMPACT CARS FORD FOCUS 2 4 Manual 26 34
COMPACT CARS FORD FOCUS 2.3 4 Manual 25 33
COMPACT CARS HONDA CIVIC 1.7 4 Auto 29 38
COMPACT CARS HONDA CIVIC 1.7 4 Manual 32 38
COMPACT CARS HONDA CIVIC HYBRID 1.3 4 Auto 48 47
COMPACT CARS HONDA CIVIC HYBRID 1.3 4 Manual 46 51
COMPACT CARS HYUNDAI ACCENT/BRIO 1.6 4 Auto 26 35
COMPACT CARS HYUNDAI ACCENT/BRIO 1.6 4 Manual 29 33
COMPACT CARS HYUNDAI ELANTRA 2 4 Auto 25 33
COMPACT CARS HYUNDAI ELANTRA 2 4 Manual 24 33
COMPACT CARS INFINITI G35 3.5 6 Auto 19 26
COMPACT CARS INFINITI G35 3.5 6 Manual 20 27
COMPACT CARS INFINITI M45 4.5 8 Auto 17 23
COMPACT CARS JAGUAR JAGUAR X-TYPE 2.5 6 Auto 19 26
COMPACT CARS JAGUAR JAGUAR X-TYPE 2.5 6 Manual 19 28
COMPACT CARS JAGUAR XJ SPORT 4 8 Auto 17 24
COMPACT CARS JAGUAR XJ8 4 8 Auto 17 24
COMPACT CARS KIA KIA RIO 1.6 4 Auto 25 32
COMPACT CARS KIA KIA RIO 1.6 4 Manual 26 33
COMPACT CARS KIA KIA SPECTRA 1.8 4 Auto 22 30
COMPACT CARS KIA KIA SPECTRA 1.8 4 Manual 24 32
COMPACT CARS LEXUS IS 300 3 6 Auto 18 24
COMPACT CARS LEXUS IS 300 3 6 Manual 18 25
COMPACT CARS MAZDA PROTEGE/PROTEGE 5 2 4 Auto 25 30
COMPACT CARS MAZDA PROTEGE/PROTEGE 5 2 4 Manual 24 30
COMPACT CARS MERCEDES-BENZ C230 KOMPRESSOR 1.8 4 Auto 23 31
COMPACT CARS MERCEDES-BENZ C230 KOMPRESSOR 1.8 4 Manual 21 30
COMPACT CARS MERCEDES-BENZ C240 2.6 6 Auto 19 25
COMPACT CARS MERCEDES-BENZ C240 2.6 6 Manual 17 26
COMPACT CARS MERCEDES-BENZ C240 (4MATIC) 2.6 6 Auto 19 25
COMPACT CARS MERCEDES-BENZ C32 AMG 3.2 6 Auto 17 21
COMPACT CARS MERCEDES-BENZ C320 3.2 6 Auto 20 26
COMPACT CARS MERCEDES-BENZ C320 3.2 6 Manual 17 25
COMPACT CARS MERCEDES-BENZ C320 (4MATIC) 3.2 6 Auto 19 25
COMPACT CARS MERCEDES-BENZ C320 SPORTS COUPE 3.2 6 Auto 19 25
COMPACT CARS MERCEDES-BENZ C320 SPORTS COUPE 3.2 6 Manual 17 25
COMPACT CARS MERCEDES-BENZ CL500 5 8 Auto 16 22
COMPACT CARS MERCEDES-BENZ CL55 AMG 5 8 Auto 14 22
COMPACT CARS MITSUBISHI LANCER 1.6 4 Auto 24 29
COMPACT CARS MITSUBISHI LANCER 1.6 4 Manual 28 33
COMPACT CARS MITSUBISHI LANCER 2 4 Manual 27 33
COMPACT CARS MITSUBISHI LANCER EVOLUTION 2 4 Manual 18 26
COMPACT CARS NISSAN SENTRA 1.8 4 Auto 28 35
COMPACT CARS NISSAN SENTRA 2.5 4 Auto 23 28
COMPACT CARS NISSAN SENTRA 1.8 4 Manual 28 36
COMPACT CARS NISSAN SENTRA 2.5 4 Manual 24 29
COMPACT CARS OLDSMOBILE ALERO 2.2 4 Auto 24 33
COMPACT CARS OLDSMOBILE ALERO 2.2 4 Manual 26 33
COMPACT CARS OLDSMOBILE ALERO 3.4 6 Auto 20 29
COMPACT CARS PONTIAC GRAND AM 2.2 4 Auto 24 33
COMPACT CARS PONTIAC GRAND AM 2.2 4 Manual 26 33
COMPACT CARS PONTIAC GRAND AM 3.4 6 Auto 20 29
COMPACT CARS PONTIAC SUNFIRE 2.2 4 Auto 24 33
COMPACT CARS PONTIAC SUNFIRE 2.2 4 Manual 26 33
COMPACT CARS SAAB SAAB 9-3 SPORT SEDAN 2 4 Auto 22 31
COMPACT CARS SAAB SAAB 9-3 SPORT SEDAN 2 4 Manual 23 31
COMPACT CARS SATURN ION 2.2 4 Auto 24 32
COMPACT CARS SATURN ION 2.2 4 Manual 26 33
COMPACT CARS SUBARU LEGACY/OUTBACK AWD 2.5 4 Auto 20 27
COMPACT CARS SUBARU LEGACY/OUTBACK AWD 2.5 4 Manual 21 27
COMPACT CARS SUBARU LEGACY/OUTBACK AWD 3 6 Auto 19 26
COMPACT CARS SUZUKI AERIO 2 4 Auto 26 31
COMPACT CARS SUZUKI AERIO 2 4 Manual 26 32
COMPACT CARS TOYOTA CAMRY SOLARA 2.4 4 Auto 23 32
COMPACT CARS TOYOTA CAMRY SOLARA 2.4 4 Manual 23 33
COMPACT CARS TOYOTA CAMRY SOLARA 3 6 Auto 20 27
COMPACT CARS TOYOTA COROLLA 1.8 4 Auto 29 38
COMPACT CARS TOYOTA COROLLA 1.8 4 Manual 32 40
COMPACT CARS TOYOTA ECHO 1.5 4 Auto 33 39
COMPACT CARS TOYOTA ECHO 1.5 4 Manual 35 43
COMPACT CARS TOYOTA PRIUS 1.5 4 Auto 52 45
COMPACT CARS VOLKSWAGEN GOLF 1.9 4 Auto 34 45
COMPACT CARS VOLKSWAGEN GOLF 2 4 Auto 23 29
COMPACT CARS VOLKSWAGEN GOLF 1.9 4 Manual 42 49
COMPACT CARS VOLKSWAGEN GOLF 2 4 Manual 24 31
COMPACT CARS VOLKSWAGEN GTI 2.8 6 Manual 21 29
COMPACT CARS VOLKSWAGEN JETTA 1.9 4 Auto 34 45
COMPACT CARS VOLKSWAGEN JETTA 2 4 Auto 23 29
COMPACT CARS VOLKSWAGEN JETTA 1.9 4 Manual 42 49
COMPACT CARS VOLKSWAGEN JETTA 2 4 Manual 24 31
COMPACT CARS VOLKSWAGEN JETTA 2.8 6 Auto 21 31
COMPACT CARS VOLKSWAGEN JETTA 2.8 6 Manual 21 29
COMPACT CARS VOLKSWAGEN PASSAT 4MOTION 2.8 6 Auto 19 26
COMPACT CARS VOLKSWAGEN PASSAT 4MOTION 4 8 Auto 18 25
COMPACT CARS VOLVO S40 1.9 4 Auto 22 30
LARGE CARS BMW 745I 4.4 8 Auto 18 26
LARGE CARS BUICK LESABRE 3.8 6 Auto 20 29
LARGE CARS BUICK PARK AVENUE 3.8 6 Auto 17 27
LARGE CARS CADILLAC DEVILLE 4.6 8 Auto 18 27
LARGE CARS CHEVROLET IMPALA 3.4 6 Auto 21 32
LARGE CARS CHEVROLET IMPALA 3.8 6 Auto 19 29
LARGE CARS CHRYSLER 300 M 3.5 6 Auto 18 27
LARGE CARS CHRYSLER CONCORDE/LHS 2.7 6 Auto 21 29
LARGE CARS CHRYSLER CONCORDE/LHS 3.5 6 Auto 19 27
LARGE CARS DODGE INTREPID 2.7 6 Auto 21 29
LARGE CARS DODGE INTREPID 3.5 6 Auto 19 27
LARGE CARS DODGE INTREPID 3.5 6 Auto 18 27
LARGE CARS FORD CROWN VICTORIA 4.6 8 Auto 18 26
LARGE CARS FORD TAURUS 3 6 Auto 20 28
LARGE CARS INFINITI Q45 4.5 8 Auto 17 23
LARGE CARS LEXUS LS 430 4.3 8 Auto 19 25
LARGE CARS LINCOLN-MERCURY GRAND MARQUIS 4.6 8 Auto 17 25
LARGE CARS LINCOLN-MERCURY MARAUDER 4.6 8 Auto 17 23
LARGE CARS LINCOLN-MERCURY TOWN CAR 4.6 8 Auto 17 25
LARGE CARS MERCEDES-BENZ S430 4.3 8 Auto 17 24
LARGE CARS MERCEDES-BENZ S430 4MATIC 4.3 8 Auto 16 22
LARGE CARS MERCEDES-BENZ S500 5 8 Auto 16 22
LARGE CARS MERCEDES-BENZ S500 4MATIC 5 8 Auto 16 21
LARGE CARS MERCEDES-BENZ S55 AMG 5 8 Auto 14 22
LARGE CARS PONTIAC BONNEVILLE 3.8 6 Auto 17 27
LARGE CARS TOYOTA AVALON 3 6 Auto 21 29
MIDSIZE CARS ACURA 3.2TL 3.2 6 Auto 19 29
MIDSIZE CARS ACURA 3.5RL 3.5 6 Auto 18 24
MIDSIZE CARS AUDI A6 3 6 Auto 20 27
MIDSIZE CARS AUDI A6 QUATTRO 2.7 6 Auto 18 25
MIDSIZE CARS AUDI A6 QUATTRO 3 6 Auto 18 26
MIDSIZE CARS AUDI A6 QUATTRO 2.7 6 Manual 18 25
MIDSIZE CARS AUDI A6 QUATTRO 4.2 8 Auto 17 25
MIDSIZE CARS AUDI A8 4.2 8 Auto 17 25
MIDSIZE CARS AUDI S8 4.2 8 Auto 16 21
MIDSIZE CARS BUICK CENTURY 3.1 6 Auto 20 29
MIDSIZE CARS BUICK REGAL 3.8 6 Auto 17 27
MIDSIZE CARS CADILLAC CTS 3.2 6 Auto 18 26
MIDSIZE CARS CADILLAC CTS 3.2 6 Manual 19 26
MIDSIZE CARS CADILLAC SEVILLE 4.6 8 Auto 18 27
MIDSIZE CARS CHEVROLET MALIBU 3.1 6 Auto 20 29
MIDSIZE CARS CHEVROLET MONTE CARLO 3.4 6 Auto 21 32
MIDSIZE CARS CHEVROLET MONTE CARLO 3.8 6 Auto 19 29
MIDSIZE CARS CHRYSLER SEBRING 4-DR 2.4 4 Auto 22 30
MIDSIZE CARS CHRYSLER SEBRING 4-DR 2.7 6 Auto 16 20
MIDSIZE CARS DODGE STRATUS 4-DR 2.4 4 Auto 22 30
MIDSIZE CARS DODGE STRATUS 4-DR 2.7 6 Auto 21 28
MIDSIZE CARS DODGE STRATUS 4-DR 2.7 6 Manual 20 27
MIDSIZE CARS HONDA ACCORD 2.4 4 Auto 24 33
MIDSIZE CARS HONDA ACCORD 2.4 4 Manual 26 34
MIDSIZE CARS HONDA ACCORD 3 6 Auto 21 30
MIDSIZE CARS HONDA ACCORD 3 6 Manual 20 30
MIDSIZE CARS HYUNDAI SONATA 2.4 4 Auto 22 30
MIDSIZE CARS HYUNDAI SONATA 2.4 4 Manual 22 30
MIDSIZE CARS HYUNDAI SONATA 2.7 6 Auto 19 27
MIDSIZE CARS HYUNDAI SONATA 2.7 6 Manual 20 27
MIDSIZE CARS HYUNDAI XG350 3.5 6 Auto 17 26
MIDSIZE CARS INFINITI I35 3.5 6 Auto 20 26
MIDSIZE CARS JAGUAR JAGUAR S-TYPE 3.0 LITRE 3 6 Auto 18 26
MIDSIZE CARS JAGUAR JAGUAR S-TYPE 3.0 LITRE 3 6 Manual 18 26
MIDSIZE CARS JAGUAR JAGUAR S-TYPE 4.2 LITRE 4.2 8 Auto 17 26
MIDSIZE CARS JAGUAR SUPER V8 4 8 Auto 16 22
MIDSIZE CARS JAGUAR VANDEN PLAS 4 8 Auto 17 24
MIDSIZE CARS KIA OPTIMA 2.4 4 Auto 22 30
MIDSIZE CARS KIA OPTIMA 2.4 4 Manual 23 30
MIDSIZE CARS KIA OPTIMA 2.7 6 Auto 20 27
MIDSIZE CARS KIA OPTIMA 2.7 6 Manual 20 28
MIDSIZE CARS LEXUS ES 300 3 6 Auto 21 29
MIDSIZE CARS LEXUS GS 300/GS 430 3 6 Auto 18 25
MIDSIZE CARS LEXUS GS 300/GS 430 4.3 8 Auto 18 23
MIDSIZE CARS LINCOLN-MERCURY LS 3 6 Auto 20 26
MIDSIZE CARS LINCOLN-MERCURY LS 3.9 8 Auto 18 24
MIDSIZE CARS LINCOLN-MERCURY SABLE 3 6 Auto 20 28
MIDSIZE CARS MAZDA MAZDA 6 2.3 4 Auto 23 29
MIDSIZE CARS MAZDA MAZDA 6 2.3 4 Manual 25 32
MIDSIZE CARS MAZDA MAZDA 6 3 6 Auto 19 27
MIDSIZE CARS MAZDA MAZDA 6 3 6 Manual 20 27
MIDSIZE CARS MERCEDES-BENZ E320 3.2 6 Auto 19 27
MIDSIZE CARS MERCEDES-BENZ E500 5 8 Auto 16 23
MIDSIZE CARS MITSUBISHI DIAMANTE SEDAN 3.5 6 Auto 17 25
MIDSIZE CARS MITSUBISHI GALANT 2.4 4 Auto 21 28
MIDSIZE CARS MITSUBISHI GALANT 3 6 Auto 20 27
MIDSIZE CARS NISSAN ALTIMA 2.5 4 Auto 23 29
MIDSIZE CARS NISSAN ALTIMA 2.5 4 Manual 23 29
MIDSIZE CARS NISSAN ALTIMA 3.5 6 Auto 19 26
MIDSIZE CARS NISSAN ALTIMA 3.5 6 Manual 21 26
MIDSIZE CARS NISSAN MAXIMA 3.5 6 Auto 20 26
MIDSIZE CARS NISSAN MAXIMA 3.5 6 Manual 21 28
MIDSIZE CARS OLDSMOBILE AURORA 4 8 Auto 17 26
MIDSIZE CARS PONTIAC GRAND PRIX 3.1 6 Auto 20 29
MIDSIZE CARS PONTIAC GRAND PRIX 3.8 6 Auto 17 27
MIDSIZE CARS SAAB SAAB 9-5 2.3 4 Auto 20 29
MIDSIZE CARS SAAB SAAB 9-5 2.3 4 Manual 22 31
MIDSIZE CARS SAAB SAAB 9-5 3 6 Auto 18 26
MIDSIZE CARS SATURN L200 2.2 4 Auto 24 32
MIDSIZE CARS SATURN L200 2.2 4 Manual 23 31
MIDSIZE CARS SATURN L300 3 6 Auto 21 29
MIDSIZE CARS TOYOTA CAMRY 2.4 4 Auto 23 32
MIDSIZE CARS TOYOTA CAMRY 2.4 4 Manual 23 33
MIDSIZE CARS TOYOTA CAMRY 3 6 Auto 20 28
MIDSIZE CARS VOLKSWAGEN PASSAT 1.8 4 Auto 21 30
MIDSIZE CARS VOLKSWAGEN PASSAT 1.8 4 Manual 22 31
MIDSIZE CARS VOLKSWAGEN PASSAT 2.8 6 Auto 19 27
MIDSIZE CARS VOLKSWAGEN PASSAT 2.8 6 Manual 20 28
MIDSIZE CARS VOLVO S80/S80 EXECUTIVE 2.9 6 Auto 20 28
pigtail
拟合以cty 、hwy为自变量的回归方程,离散的采用哑变量就ok了
neige
what is the question again? is there a question here
blue_blue
不知道这个问题是不是需要设定虚拟变量啊,而且我觉得cty 、hwy是不是应该作为因变量呢,呵呵,相互学习中
sos
问题是:'根据以下数据,建立一个能估计一个在公路上驾驶汽车油耗;和在城市驾驶汽车油耗的估计的回归方程
'
我想到了用虚拟变量,但是,有些定性因子X(例如:Manufacturer:为汽车厂家, carline name为汽车名称)水平数太多,如果设置虚拟变量,需要几百个,这样对么?
各位大侠,还请帮帮忙了,有谁能帮我做做这道题呀,时间紧迫
(对了,系统工具应该是minitab or excell)
sos
谁要是有解题过程提供,不胜感激!
对了,不太明白,为何要"cty 、hwy为自变量X"呢?那么Y是什么呢?,水平有限,弱弱的问……
sos
再有,如果用了dummy变量后,如何用 MINITAB软件实现多步回归呢?
因为这些不同的分类变量X(例如:Manufacturer:为汽车厂家, carline name为汽车名称)
转化成哑变量的形式后,如果拟合方程式采用逐步进入法,那么几个变量表示的某一分类的变量应当同时进入方程或退出方程,这样的话如何在minitab中实现,因为统计软件会把他们但做几个变量来对待
blue_blue
你的数据格式很乱,我导入EXCEL后还是没有成型,你发给我我可以试试,但不一定有好结果啊
我做可能会用SPSS,还不知道有minitab这个工具呢,学习中
sos
blue_blue,如何发送你,有mail地址么?
blue_blue
资料里有
abel
in R, try as fellowing:
cty.lm <- lm(cty ~ Class+Manufacturer+carlinename+displ+cyl+trans)
hwy.lm <- lm(hwy ~ Class+Manufacturer+carlinename+displ+cyl+trans)
step(cty.lm)
step(hwy.lm)
yihui
岂不是无数哑变量?这种回归不太好。
sos
有好的方法么?
Statsfu
我觉得数据很垃圾,最讨厌这种数据了。我的结果就是没法分析,给个mean可以。当然也可以缩小点范围,可能会产生variance.赫赫,每个只有一个,都没有replicates.
robustreg
建议把频率很小的类别去掉吧,,,另外,这个数据我写文章发表可以不????嘿嘿
MINITAB是个很著名的起初是为教学用的软件,里面还是有些特色功能滴,,,目前似乎在6sigma质量控制应用中进入大陆,,,