business statistics

profileSamuel G
BUS201FINALEXAM.xlsx

Instructions

NAME
COURSE ID
EMAIL
INSTRUCTION
Answer ALL questions
Each question is 10 points
No make up for this test.
Exam due Friday Dec. 10th @ 11:59.
Submit a copy on google class room and a coppy on wuv.edu

Q1

Lower Upper F X FX (X-M)^2 F(X-M)^2 CF
100 199 15
200 299 18
300 399 17
400 499 16
500 599 14
MEAN
VARIANCE
SD
MODE
MEDIAN

Q2

numbers
49.835 MIN MEAN
23.615 Q1 MODE
34.042 Q2 MEDIAN
13.792 Q3 VARIANCE
19.167 MAX SD
46.981
49.309
31.540
22.699
38.621
23.345
16.981
44.316
32.557
33.916
14.054
16.010
45.806
15.723
29.141

Q3

X PROB
A 0.25
B 0.15
C 0.1
D 0.2
E 0.12
F 0.18
P(A&C)
P(A&B&E)
P(NOT D)
P(NOT A&F)
P(D1)
P(B OR E)
P(F&D) OR P(B)

Q4

Mean(U) 18.2 Mean(U) 20.3 Mean(U) 21.3
Population sd 5.3 Population sd 7.4 sample SD 7
X 19.3 X 21.8 X 23.5
n 15 n 16
Z (Calculated)
Z (Table value) Z (Calculated) t (Calculated)
Z (Table value) t (Table value)

Q5

Data Data Data
Sample Standard Deviation 290.85 Sample Standard Deviation 290.85 Sample Standard Deviation 290.85
Sample Mean 1200.35 Sample Mean 1200.35 Sample Mean 1200.35
Sample Size 1020 Sample Size 1020 Sample Size 1020
Confidence Level 95% Confidence Level 90% Confidence Level 99%
Upper Limit Upper Limit Upper Limit
Lower Limit Lower Limit Lower Limit
Find CI

Q6

DEVICES Value PIE CHART BAR CHART
Tele set 60
Tablet 29
Smartphone 30
Laptop 52
LINE GRAPH

Q7

AD BD MD
AD = Associate Degree Female 12 50 38
BD = Bachelors Degree Male 24 45 42
MD = Masters Degree
Run a CHI SQUARE DIST
Significant Level = 0.05

Q8

Price(000) SqFt
Let Price = X Independent 243 1514
Let SqFt = Y Dependent 312 1600
279 1700
Run a REGRESSION LINE 312 1875
Show the REGRESSION Equation 199 1123
221 1550
405 2354
324 2450
322 1425
255 1700

Q9

MA = Moving Avereage Graph
Find 2, 3, 4 and 5 Years MA Years Sales 2 yr MA 3 Yr MA 4 yrs MA 5 yrs MA
Plot all result on one graph 1 23
2 40
3 25
TIME SERIES ANALYSIS 4 27
5 32
6 48
7 33
8 37
9 37
10 50
11 40

Q10

What topic in statististics is most important to you and why?
1
How do you plan to use this subject outcide of class?
2
What do you like and not like most about this class?
3