FINAL FOR JOHN CANTHAR ONLY

profilebeautyfull
qnt-561_final_exam.xlsx
Home>Business & Finance homework help>Management homework help>FINAL FOR JOHN CANTHAR ONLY

Sheet1

IS THERE A DIFFERENCE BETWEEN GROUPS AND WITHIN GROUPS
DETERMINE USING THE P-VALUE .
TWO-WAY ANOVA ANALYSIS
athlete javelin shot put 400 meter 100 meter
1 345 167 18.5 10
2 388 178 22.6 11
3 492 190 24.1 12
4 167 188 17.2 10
5 289 199 18 10.8
6 345 178 19 10.7
7 256 145 26 11.8
8 589 167 16.8 11.88
9 467 189 20 12
10 498 191 21.9 15
11 367 168 17.8 9.9
12 262 266 15.99 9.25
13 363 187 22 12.66
14 500 189 23 10.1
15 399 198 14.98 9.56
WHICH ATHLETE IS BEST IN JAVELIN?
WHICH ATHLETE IS BEST IN SHOT PUT?
WHICH ATHLETE IS BEST IN 400 METER? THE LOWER THE SCORE THE BETTTER THE SCORE
WHICH ATHLETE IS BEST IN THE 100 METER? THE LOWER THE SCORE THE BETTER THE SCORE.
WHICH OF OUR ATHLETES IS BEST OVER ALL?
WE HAVE 15 ATHLETES HERE WHICH ONES WILL GO TO THE NEXT HEAT. YOU MUST CHOOSE THE TOP 5.

Sheet2

ANALYZE TO SEE IF THE SHIPMENT SHOULD GO THROUGH OR NOT
EACH PACKAGE SHOULD NOT EXCEED 8 POUNDS
DESCRIPTIVE ANALYSIS
8
7.6 IS THE SET SKEWED?
7.9 IS THE SET NORMAL?
8 WHAT IS THE NUMBER FOR THE KURTOSIS?
7.2 IS THE KURTOSIS FLAT, TALL, OR NORMAL?
8.2
8.1
7
7.2
7.35
7.98
7.7
6.98
8.1
8.2
7.99
7.45

Sheet3

IS THERE A SIGNIFICANT DIFFERENCE BETWEEN THE TWO
FORCES IN TERMS OF SALES. T-TEST
141000 99000
133000 100000
125000 89000
119000 99000
99000 86000
345000 87000
200000 125000
99000 65000
199000 2500000
300455 87000
USE THE T-CRITICAL AND USE THE P-VALUE TEST TO DETERMINE THIS.
DOES THE T-CRITICAL TEST AND THE P-VALUE GIVE YOU THE SAME DECISION OR NOT, PLEASE EXPLAIN?

Sheet6

11000
12000
11500
14000
12345
14000
9000
15000
11000
45000
11678
15000
PLEASE ANALYZE DATA SET TO SEE IF MONTHLY SELLS MEET OR EXCEED THE
TARGET OF 13000.00 PER MONTH. DESCRIPTIVE ANALYSIS

Sheet7

number/people time days marketing revenue
2 5 5000 10000
3 6 1256 15000
1 2 3400 5000
1 3 4567 16000
1 1 3456 4566
1 2 1250 4000
2 1 1000 2300
1 1 2000 4500
3 2 2500 7500
1 2 4000 5678
2 1 6000 4000
3 4 12000 17500
5 1 15000 100000
7 3 24000 250000
8 4 35000 34000
6 2 4000 150000
2 2 10000 100000
1 2 10000 245000
3 2 25000 15000
4 2 30000 267000
4 1 50000 300000
2 4 2356 25000
3 5 25670 65666
2 5 15000 266877
Do a multiple regression analysis
which variable is the most powerful in increasing revenue?
Which are independent variables?
Which are the dependent variables?
Which variable would you throw out do to its ineffectiveness?