MIS770 Foundation Skills in Data AnalysisDEPARTMENT OF INFORMATION SYSTEMS AND BUSINESS ANALYTICS DEAKIN BUSINESS SCHOOL FACULTY OF BUSINESS AND LAW, DEAKIN UNIVERSITY Assignment Two...

1 answer below »

View more »
Answered 1 days AfterJan 09, 2023

Answer To: MIS770 Foundation Skills in Data AnalysisDEPARTMENT OF INFORMATION SYSTEMS AND BUSINESS ANALYTICS...

Mohd answered on Jan 11 2023
47 Votes
Executive Summary:
The summary statistics of efficiency_whkm (average consumption of the battery in watt hours for each kilometer traveled). For the variable Bodystyle, we have drawn percentage frequency bar chart to show the variation in different body style according to their relative frequency percentage. For both continuous variable we have conducted correlation test. The scat
terplot between top speed and price of the car shows positive slope, which implies increase in one will cause significant increase in other. The correlation coefficient is higher than 0.75. which is strong and positive. There is high degree dependence of topspeed over the price. There is also some exception like price is around 150000 and speed around 150. There is a significant strong relationship between price and top speed.
For assessment of relationship between powertrain and bodystyle, both are categorical variable hence we have conducted chi square test we will use chi square test. There are three types of powertrain like AWD, FWD and RWD and five types of BodyStyle. First, we have calculated cross tabulation of powertrain and bodystyle frequency. Similarly created estimated table for relative expected frequency in respective categories levels. We have tested hypothesis to estimate the acceleration for car 0 to 100 m/s in less than 7 seconds. We have tested hypothesis to estimate the that less than 20 percent of EVs belong to segment D.
Introduction:
The summary statistics of efficiency_whkm (average consumption of the battery in watt hours for each kilometer traveled) has shown in below table. Efficiency has average of 188.90 with standard error of 3.07 at five percent level of significance. It has minimum of 104 and maximum of 270 with the range of 166. The kurtosis and skewness are less than 1 and greater than 0 which implies our EV efficiency distribution is approximately normal. From confidence interval statistics we can conclude that at five percent level of significance the average estimate can vary from 182.71 to 194.89.
    Summary Statistics
    Efficiency_WhKm
     
     
    Mean
    188.80
    Standard Error
    3.07
    Median
    180.50
    Mode
    168.00
    Standard Deviation
    29.42
    Sample Variance
    865.37
    Kurtosis
    0.92
    Skewness
    0.78
    Range
    166.00
    Minimum
    104.00
    Maximum
    270.00
    Sum
    17370.00
    Count
    92.00
    Confidence Level(95.0%)
    6.09
For the variable Bodystyle, we have drawn percentage frequency bar chart to show the variation in different body style according to their relative frequency percentage. BodyStyle SUV accounts for 49 percent of total vehicles on the contrary bodystyle Pickup accounts for only 3 percent of total vehicles.
The scatterplot between top speed and price of the car shows positive slope, which implies increase in one will cause significant increase in other. The correlation coefficient is 0.77 which is strong and positive. There is high degree dependence of topspeed over the price. There is also some exception like price is around 150000 and speed around 150. There is a strong relationship between price and top speed.
For assessment of relationship between powertrain and bodystyle we will use chi square test. There are three types of powertrain like AWD, FWD and RWD and five types of BodyStyle.
First, we have calculated cross tabulation of powertrain and bodystyle frequency. Similarly created estimated table for relative expected frequency in respective categories levels.
    Observed
    
    
    
    
    
    
    Powertrain\BodyStyle
    Hatchback
    Liftback
    Pickup
    Sedan
    SUV
    Grand Total
    AWD
    3
    4
    2
    8
    22
    39
    FWD
    16
    1
    
    
    15
    32
    RWD
    10
    
    1
    2
    8
    21
    Grand Total
    29
    5
    3
    10
    45
    92
    
    
    
    
    
    
    
    Expected
    
    
    
    
    
    
    Powertrain\BodyStyle
    Hatchback
    Liftback
    Pickup
    Sedan
    SUV
    Grand...
SOLUTION.PDF

Answer To This Question Is Available To Download

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30