302 Wk5 Discussion Excel Insert
xlsx
keyboard_arrow_up
School
American Public University *
*We aren’t endorsed by this school
Course
302
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
xlsx
Pages
14
Uploaded by HighnessElephantMaster98
Vehicle Type
Year
Make
Model
Price
Sedan 2020
KIA
Optima 4S
22,960
19
Sedan
2024
KIA
Niro Hybrid LX
26,840
45
SUV
2015
Jeep
Wrangler Unlimted
23,000
11
SUV
2024
Jeep
Wrangler
30,295
15
Truck
2023
Chevrolet
Silverado 1500
55,300
18
Sports
2023
Dodge
Challenger CT
33,027
19
SUV
2005
Jeep
Wrangler Unlimted
10,130
16
SUV
2022
Mitsubishi
Eclipse Cross
23,695
25
SUV
2022
Toyota
RAV4
26,525
28
Sedan
2023
Honda
Accord Hybrid
31,736
44
Qualitative
Quantitative Qualitative
Qualitative
Quantitative Quantitative MPG - City
Cylinder
Liter
Drivetrain
42
4 Cyl
2.4 Liter
FWD
53
4 Cyl
1.6 Liter
FWD
14
V6
3.6 Liter
4WD
21
V6
3.6 Liter
4WD
21
8 Cyl
5.3 Liter
4WD
30
6 Cyl
3.6 Liter
RWD
19
6 Cyl
4.0 Liter
4WD
27
4 Cyl
1.5 Liter
FWD
30
4 Cyl
2.5 Liter
FWD
48
4 Cyl
2.0 Liter
FWD
Quantitative Quantitative Quantitative Qualitative
MPG - Highway
Price
$22,960
$26,840
$23,000
$30,295
$55,300
$33,027
$10,130
$23,695
$26,525
$31,736
Mean:
$28,351
Median:
$26,840
SD:
10367.9572
Sample Size:
10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Price
Mean
28350.8
Standard Error
3621.46010087399
Median
26682.5
Mode
#N/A
Standard Deviation
11452.0623741849
Sample Variance
131149732.622222
Kurtosis
3.78737401968821
Skewness
1.22535714696287
Range
45170
Minimum
10130
Maximum
55300
Sum
283508
Count
10
Confidence Level(95.0%)
8192.31190698
Price
$22,960
$26,840
$23,000
$30,295
$55,300
$33,027
$10,130
$23,695
$26,525
$31,736
$1,000,000
Mean:
$116,683
Median:
$26,840
SD:
293164.637
Sample Size:
11
Price
Mean
116682.545454545
Standard Error
88392.4639758147
Median
26840
Mode
#N/A
Standard Deviation
293164.637302784
Sample Variance
85945504564.8727
Kurtosis
10.9596409672534
Skewness
3.30834172590969
Range
989870
Minimum
10130
Maximum
1000000
Sum
1283508
Count
11
Confidence Level(95.0
196950.68320731
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Car Price:
Car Price:
1 Observation 1
22,960
2 Observation 1
22,960
3
Observation 2
26,840
Observation 2
26,840
Observation 3
23,000
Observation 3
23,000
Observation 4
30,295
Observation 4
30,295
Observation 5
55,300
Observation 5
55,300
Observation 6
33,027
Observation 6
33,027
Observation 7
10,130
Observation 7
10,130
Observation 8
23,695
Observation 8
23,695
Observation 9
26,525
Observation 9
26,525
Observation 10
31,736
Observation 10
31,736
Mean:
28,351
Mean:
28,351
p
0.6
p
0.6
q
0.4
q
0.4
P(x = 4)
0.111476736
P(x = < 4)
0.16623862
Precentage
11.15%
Percentage
16.62%
Car Price:
Car Price:
Observation 1
22,960
4 Observation 1
22,960
Observation 2
26,840
Observation 2
26,840
Observation 3
23,000
Observation 3
23,000
Observation 4
30,295
Observation 4
30,295
Observation 5
55,300
Observation 5
55,300
Observation 6
33,027
Observation 6
33,027
Observation 7
10,130
Observation 7
10,130
Observation 8
23,695
Observation 8
23,695
Observation 9
26,525
Observation 9
26,525
Observation 10
31,736
Observation 10
31,736
Mean:
28,351
Mean:
28,351
p
0.6
p
0.6
q
0.4
q
0.4
P(x = >6)
0.3822806
0.94523812
Percentage
38.23%
Percentage
94.52%
P(x = >
4)
1
Price
2
Price
3
$22,960
$22,960
$26,840
$26,840
$23,000
$23,000
$30,295
$30,295
$55,300
$55,300
$33,027
$33,027
$10,130
$10,130
$23,695
$23,695
$26,525
$26,525
$31,736
$31,736
Mean:
$28,351
Mean:
$28,351
Mean:
Median:
$26,840
Median:
$26,840
Median:
SD:
10367.9572
SD:
10367.9572
SD:
Sample Size:
10
Sample Size:
10
Sample Size:
New SD
5183.9786
New SD
5183.9786
New SD
Sample Size:
4
Sample Size:
4
Sample Size:
P (x < 27,851)
0.46158119
P (x > 29,351)
0.42351785
P (x = mean)
Percentage
46.16%
Percentage
42.35%
Percentage
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Price
4
Price
$22,960
$22,960
$26,840
$26,840
$23,000
$23,000
$30,295
$30,295
$55,300
$55,300
$33,027
$33,027
$10,130
$10,130
$23,695
$23,695
$26,525
$26,525
$31,736
$31,736
$28,351
Mean:
$28,351
$26,840
Median:
$26,840
10367.957196
SD:
10367.9572
10
Sample Size:
10
5183.9785978
New SD
5183.9786
4
Sample Size:
4
1.539136E-06
0.22768878
0.00%
Percentage
22.77%
P (26851 <
x <
29851
Price
Oringinal Price
$22,960
$26,840
Mean
28350.8
$23,000
Standard Error (SE)
3621.46010087399
$30,295
Median
26682.5
$55,300
Mode
#N/A
$33,027
Standard Deviation
11452.0623741849
$10,130
Sample Variance
131149732.622222
$23,695
Kurtosis
3.78737401968821
$26,525
Skewness
1.22535714696287
$31,736
Range
45170
Mean:
$28,351
Minimum
10130
Median:
$26,840
Maximum
55300
SD:
10367.9571956538
Sum
283508
Sample Size:
10
Count
10
Confidence Level(95.0%)
8192.31190698
T Critical Value
2.2621571627982
Wk5 Confidence
Mean
28350.8
Standard Error (SE)
3621.46010087399
Median
26682.5
Mode
#N/A
Standard Deviation
11452.0623741849
Sample Variance
131149732.622222
Kurtosis
3.78737401968821
Skewness
1.22535714696287
Range
45170
Minimum
10130
Maximum
55300
Sum
283508
Count
10
Confidence Level(95.0%)
8192.31190698
T Critical Value
2.2621571627982
SE
3621.460101
Question1
Mean
28350.8
Standard Error
3621.46010087399
Median
26682.5
Mode
#N/A
Standard Deviation
11452.0623741849
Sample Variance
131149732.622222
Kurtosis
3.78737401968821
Skewness
1.22535714696287
Range
45170
Minimum
10130
Maximum
55300
Sum
283508
Count
10
Confidence Level(90.0%)
6638.54534601067
T Critical Value
2.2621571627982
SE
3621.460101
ME
8192.311907
Question 1
Mean
28350.8
Standard Error
3621.46010087399
Median
26682.5
Mode
#N/A
Standard Deviation
11452.0623741849
Sample Variance
131149732.622222
Kurtosis
3.78737401968821
Skewness
1.22535714696287
Range
45170
Minimum
10130
Maximum
55300
Sum
283508
Count
10
Confidence Level(88.0%)
6220.14371306165
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Question 2
Mean
28350.8
Standard Error
3621.46010087399
Median
26682.5
Mode
#N/A
Standard Deviation
11452.0623741849
Sample Variance
131149732.622222
Kurtosis
3.78737401968821
Skewness
1.22535714696287
Range
45170
Minimum
10130
Maximum
55300
Sum
283508
Count
10
Confidence Level(97.0%)
9320.92841215651
T Critical Value 2.573804
3.16227
28352
3621.63961
24910
32,154
Question 2
Mean
28350.8
Standard Error
3621.46010087399
Median
26682.5
Mode
#N/A
Standard Deviation
11452.0623741849
Sample Variance
131149732.622222
Kurtosis
3.78737401968821
Skewness
1.22535714696287
Range
45170
Minimum
10130
Maximum
55300
Sum
283508
Count
10
Confidence Level(64.0%)
3492.85297518232