Questions
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can...

Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses.

1. Mean sales per week exceed 42.5 per salesperson

2. Proportion receiving online training is less than 55%

3 Mean calls made among those with no training is at least 145

4. Mean time per call is 14.7 minutes

Using the same data set from part A, perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's belief. Use the Eight Steps of a Test of Hypothesis from Section 9.1 of your text book as a guide. You can use either the p-value or the critical values to draw conclusions. Be sure to explain your conclusion and interpret that to the claim in simple terms

Compute 99% confidence intervals for the variables used in each hypothesis test, and interpret these intervals.

Write a report about the results, distilling down the results in a way that would be understandable to someone who does not know statistics. Clear explanations and interpretations are critical.

Summary Report (about one paragraph on each of the four speculations)

Appendix with the calculations of the Eight Elements of a Test of Hypothesis, the p-values, and the confidence intervals. Include the Excel formulas or spreadsheet screen shots used in the calculations. 40 144 17.4 0.00 NONE 46 145 16.8 0.00 ONLINE 37 152 19.8 0.00 NONE 47 164 15.3 0.00 ONLINE 42 135 16.1 0.00 NONE 44 169 8.9 0.00 ONLINE 52 173 18.6 0.00 ONLINE 53 184 15.2 0.00 ONLINE 49 152 22.3 0.00 ONLINE 49 166 16.2 0.00 ONLINE 45 185 13.3 1.00 ONLINE 47 157 14.3 1.00 GROUP 42 148 16.9 1.00 NONE 43 131 18.5 1.00 NONE 44 150 18.4 1.00 NONE 43 148 15.9 1.00 ONLINE 55 189 12 1.00 ONLINE 49 188 20.4 1.00 NONE 51 190 11.3 1.00 ONLINE 37 137 18.1 1.00 ONLINE 51 167 16.2 1.00 ONLINE 37 130 15.6 1.00 GROUP 37 142 18.5 1.00 NONE 46 153 14.1 1.00 ONLINE 39 149 18.8 1.00 GROUP 46 151 16 1.00 GROUP 45 158 13.9 1.00 ONLINE 46 172 12.5 1.00 ONLINE 47 188 16.3 1.00 NONE 37 148 16.2 1.00 GROUP 46 162 12.1 1.00 GROUP 52 177 14.5 1.00 ONLINE 48 175 13.7 1.00 ONLINE 40 150 10.8 1.00 GROUP 53 182 10.5 1.00 ONLINE 54 197 11.8 1.00 ONLINE 46 148 13.1 1.00 GROUP 41 153 14.7 1.00 GROUP 44 169 13.6 1.00 ONLINE 47 176 14.1 2.00 ONLINE 47 183 12.8 2.00 ONLINE 48 136 14.1 2.00 ONLINE 52 197 13.9 2.00 ONLINE 37 120 12 2.00 NONE 49 184 16.7 2.00 ONLINE 43 173 19.8 2.00 ONLINE 42 153 15.5 2.00 GROUP 37 133 19.8 2.00 NONE 42 154 14.8 2.00 ONLINE 53 178 13.2 2.00 ONLINE 45 138 18.9 2.00 NONE 42 167 18 2.00 NONE 48 171 13 2.00 GROUP 46 162 16.2 2.00 ONLINE 49 149 21.1 2.00 GROUP 48 174 18.6 2.00 GROUP 45 173 17.6 2.00 ONLINE 45 155 18.9 2.00 GROUP 44 159 18.1 2.00 ONLINE 54 174 10.8 2.00 NONE 44 139 15.2 2.00 NONE 41 158 19.3 2.00 ONLINE 43 145 18.6 2.00 NONE 47 193 13.5 2.00 ONLINE 38 145 17.1 2.00 NONE 50 184 15.6 2.00 ONLINE 41 128 15.5 2.00 NONE 45 177 14.2 2.00 GROUP 49 170 16.1 3.00 NONE 38 122 19.3 3.00 GROUP 46 171 13.6 3.00 GROUP 37 148 15.7 3.00 GROUP 42 167 17.7 3.00 ONLINE 44 148 13.5 3.00 GROUP 45 164 16.7 3.00 NONE 45 146 12 3.00 GROUP 48 177 13.9 3.00 ONLINE 49 160 13.6 3.00 GROUP 46 149 17.8 3.00 NONE 45 140 11 3.00 GROUP 45 130 20.6 3.00 GROUP 43 166 17.6 3.00 ONLINE 44 188 12.9 3.00 GROUP 41 157 11.5 3.00 ONLINE 41 155 13.6 3.00 GROUP 43 153 15.2 3.00 GROUP 37 145 18 3.00 NONE 34 133 15.2 4.00 GROUP 51 177 11.4 4.00 NONE 43 169 13.3 4.00 NONE 39 156 13.3 4.00 NONE 40 125 12.2 5.00 NONE 44 182 15.5 5.00 NONE 48 156 15.1 4.00 ONLINE 43 148 14.5 4.00 ONLINE 39 138 17.7 4.00 GROUP 42 160 10.6 4.00 NONE 54 180 11.8 5.00 GROUP 51 167 12.6 6.00 ONLINE 48 165 19.8 6.00 ONLINE and i have answered from Q1 to Q4 SO i need the rest


Sales (Y) Calls (X1) Time (X2) Years (X3) Type
21 116 19.9 3 NONE
21 116 18.0 2 GROUP
31 118 19.4 4 ONLINE
33 125 16.9 2 ONLINE
32 129 18.5 2 GROUP
29 131 14.6 1 GROUP
33 131 10.0 0 GROUP
42 131 19.4 5 GROUP
40 132 18.5 1 GROUP
33 135 15.3 2 GROUP
33 136 16.9 4 ONLINE
41 136 19.3 3 ONLINE
45 137 15.7 1 GROUP
42 139 12.4 1 GROUP
33 140 17.5 2 GROUP
41 140 13.9 3 NONE
42 141 12.2 3 NONE
42 142 17.0 3 ONLINE
35 143 17.7 3 NONE
40 143 18.3 2 NONE
32 146 15.4 3 GROUP
34 146 15.8 1 GROUP
40 146 18.2 2 NONE
43 146 16.4 0 ONLINE
44 146 16.5 1 NONE
45 146 15.6 3 ONLINE
41 147 18.5 3 GROUP
42 147 13.2 3 GROUP
42 148 10.5 2 GROUP
40 149 14.2 4 ONLINE
41 149 13.2 3 GROUP
43 149 12.7 1 GROUP
32 150 19.4 0 GROUP
43 150 17.4 3 GROUP
46 150 20.7 2 GROUP
41 151 18.0 1 NONE
43 151 14.3 1 GROUP
44 151 15.2 2 GROUP
43 152 17.2 1 GROUP
44 152 16.0 2 ONLINE
43 153 13.2 3 GROUP
46 153 22.0 0 ONLINE
40 154 16.4 3 GROUP
41 154 14.5 4 NONE
43 154 15.3 1 ONLINE
43 155 11.2 3 ONLINE
42 156 18.6 2 GROUP
43 156 20.5 2 ONLINE
45 157 16.3 4 ONLINE
46 157 19.3 2 ONLINE
44 158 13.9 1 GROUP
44 158 11.8 3 ONLINE
42 159 13.6 4 GROUP
48 160 15.8 2 ONLINE
46 161 13.2 3 GROUP
46 162 15.7 3 NONE
47 162 16.4 3 ONLINE
43 163 11.7 1 GROUP
45 164 17.2 3 ONLINE
44 165 17.4 3 ONLINE
44 165 15.0 0 ONLINE
44 165 19.2 2 NONE
45 166 19.5 5 NONE
45 167 14.5 4 GROUP
46 167 10.1 0 ONLINE
46 167 14.8 1 ONLINE
46 167 15.8 0 ONLINE
48 168 12.3 5 ONLINE
48 168 15.9 5 ONLINE
46 169 14.8 3 GROUP
48 170 12.1 1 ONLINE
45 171 19.4 2 ONLINE
47 171 17.3 2 ONLINE
45 172 12.6 3 GROUP
50 173 13.3 1 ONLINE
49 174 18.3 0 ONLINE
45 175 18.3 2 GROUP
47 175 13.9 2 GROUP
50 175 15.1 3 ONLINE
51 175 12.0 2 ONLINE
54 175 14.2 1 ONLINE
44 177 15.3 3 ONLINE
48 178 12.6 4 ONLINE
50 179 12.8 3 ONLINE
46 180 15.1 4 NONE
49 181 12.4 2 ONLINE
51 181 11.4 4 GROUP
51 182 17.9 2 ONLINE
47 183 13.0 3 ONLINE
50 183 11.7 1 GROUP
47 185 15.2 2 ONLINE
50 185 16.4 0 ONLINE
46 186 14.1 3 GROUP
49 186 17.5 1 GROUP
53 188 11.0 2 ONLINE
46 189 20.0 1 GROUP
52 190 13.2 3 ONLINE
49 191 13.1 2 GROUP
54 195 15.2 2 ONLINE
51 198 13.0 1 ONLINE

In: Statistics and Probability

An air-conditioning supplier uses two installers. He is interested in comparing the time each installer takes...

An air-conditioning supplier uses two installers. He is interested in comparing the time each installer takes to install an air-conditioning unit. Data concerning installation times was collected over a period of time, and the following results were determined. (Note: the installation times are in hours).

Sample Mean Sample Standard Deviation Sample Size
Installer A 3 1.1952 8
Installer B 4 1.4142 7

Is there evidence, at the 5% level of significance, of a difference in the average time of installation between the two installers? (You may assume that all installation times are normally distributed, and Installer A and Installer B have equal population variances). You may use the following Excel output.

t-Test: Two-Sample Assuming Equal Variances

Installer A Installer B
Mean 3 4
Variance 1.429 2.000
Observations 8 7
Pooled Variance 1.692
Hypothesized Mean Difference 0
df 13
t Stat -1.485
P(T<=t) one-tail 0.081
t Critical one-tail 1.771
P(T<=t) two-tail 0.161
t Critical two-tail 2.160

In: Statistics and Probability

Calculate the Cash Flow from Operating Activities for 2018 Jenny's Retail USA 12/31/2018 Balance Sheet in...

Calculate the Cash Flow from Operating Activities for 2018

Jenny's Retail USA
12/31/2018
Balance Sheet
in $000
2017 2018
Cash             27                5
A/R             30             31
Inventory             11             30
Total Current Assets             68             66
Gross Plant & Equipment           140           180
Less: Depreciation            (40)            (50)
Net Plant & Equipment           100           130
Total Assets           168           196
Liabilities
A/P             15             14
Accruals             15                2
Current Liabilities             30             16
Long-term Debt             50             76
Common Stock             15             25
RE             73             79
Total Liabilities & Equity           168           196


Jenny's Retail USA
12/31/2018
Income Statement
in $000
Revenue                  35
COGS                    5
Gross Margin                  30
Expense                    7
Depreciation                  10
EBIT                  13
Interest                    2
EBT                  11
Taxes                    5
Net Income                    6

In: Finance

According to an​ article, 37​% of adults have experienced a breakup at least once during the...

According to an​ article, 37​% of adults have experienced a breakup at least once during the last 10 years. Of 9 randomly selected​ adults, find the probability that the​ number, X, who have experienced a breakup at least once during the last 10 years is a. exactly​ five; at most​ five; at least five. b. at least​ one; at most one. c. between two and four​, inclusive. d. Determine the probability distribution of the random variable X. a. The probability that exactly five adults have experienced a breakup at least once during the last 10 years is nothing. ​(Round to four decimal places as​ needed.) The probability that at most five adults have experienced a breakup at least once during the last 10 years is nothing. ​(Round to four decimal places as​ needed.) The probability that at least five adults have experienced a breakup at least once during the last 10 years is nothing. ​(Round to four decimal places as​ needed.) b. The probability that at least one adult has experienced a breakup at least once during the last 10 years is nothing. ​(Round to four decimal places as​ needed.) The probability that at most one adult has experienced a breakup at least once during the last 10 years is nothing. ​(Round to four decimal places as​ needed.) c. The probability that between two and four ​adults, inclusive, have experienced a breakup at least once during the last 10 years is nothing. ​(Round to four decimal places as​ needed.) d. Complete the table below to determine the probability distribution of X. x Upper P left parenthesis Upper X equals x right parenthesis x Upper P left parenthesis Upper X equals x right parenthesis 0 nothing 5 nothing 1 nothing 6 nothing 2 nothing 7 nothing 3 nothing 8 nothing 4 nothing 9 nothing ​(Round to four decimal places as​ needed.) Enter your answer in each of the answer boxes.

In: Statistics and Probability

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately...

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided. 3.1 Use the least squares method to estimate the regression coefficients b0 and b1 3.2 State the regression equation 3.3 Plot on the same graph, the scatter diagram and the regression line3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%) Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem 3.6 Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

STARS Total_Rooms Region_ID ARR_MAY ARR_AUG L_COST
5 412 1 95 160 2.165.000
5 313 1 94 173 2.214.985
5 265 1 81 174 1.393.550
5 204 1 131 225 2.460.634
5 172 1 90 195 1.151.600
5 133 1 71 136 801.469
5 127 1 85 114 1.072.000
4 322 1 70 159 1.608.013
4 241 1 64 109 793.009
4 172 1 68 148 1.383.854
4 121 1 64 132 494.566
4 70 1 59 128 437.684
4 65 1 25 63 83.000
3 93 1 76 130 626.000
3 75 1 40 60 37.735
3 69 1 60 70 256.658
3 66 1 51 65 230.000
3 54 1 65 90 200.000
2 68 1 45 55 199.000
1 57 1 35 90 11.720
4 38 1 22 51 59.200
4 27 1 70 100 130.000
3 47 1 60 120 255.020
3 32 1 40 60 3.500
3 27 1 48 55 20.906
2 48 1 52 60 284.569
2 39 1 53 104 107.447
2 35 1 80 110 64.702
2 23 1 40 50 6.500
1 25 1 59 128 156.316
4 10 1 90 105 15.950
3 18 1 94 104 722.069
2 17 1 29 53 6.121
2 29 1 26 44 30.000
1 21 1 42 54 5.700
1 23 1 30 35 50.237
2 15 1 47 50 19.670
1 8 1 31 49 7.888
1 20 1 35 45 0
1 11 1 40 55 0
1 15 1 40 55 3.500
1 18 1 35 40 112.181
3 23 1 40 55 0
4 10 1 57 97 30.000
2 26 1 35 40 3.575
5 306 2 113 235 2.074.000
5 240 2 61 132 1.312.601
5 330 2 112 240 434.237
5 139 2 100 130 495.000
4 353 2 87 152 1.511.457
4 324 2 112 211 1.800.000
4 276 2 95 160 2.050.000
4 221 2 47 102 623.117
4 200 2 77 178 796.026
4 117 2 48 91 360.000
3 170 2 60 104 538.848
3 122 2 25 33 568.536
5 57 2 68 140 300.000
4 62 2 55 75 249.205
3 98 2 38 75 150.000
3 75 2 45 70 220.000
3 62 2 45 90 50.302
5 50 2 100 180 517.729
4 27 2 180 250 51.000
3 44 2 38 84 75.704
3 33 2 99 218 271.724
3 25 2 45 95 118.049
2 42 2 28 40 0
2 30 2 30 55 40.000
1 44 2 16 35 0
3 10 2 40 70 10.000
2 18 2 60 100 10.000
1 18 2 16 20 0
2 73 2 22 41 70.000
2 21 2 55 100 12.000
1 22 2 40 100 20.000
1 25 2 80 120 36.277
1 25 2 80 120 36.277
1 31 2 18 35 10.450
3 16 2 80 100 14.300
2 15 2 30 45 4.296
1 12 2 40 65 0
1 11 2 30 50 0
1 16 2 25 70 379.498
1 22 2 30 35 1.520
4 12 2 215 265 45.000
4 34 2 133 218 96.619
2 37 2 35 95 270.000
2 25 2 100 150 60.000
2 10 2 70 100 12.500
5 270 3 60 90 1.934.820
5 261 3 119 211 3.000.000
5 219 3 93 162 1.675.995
5 280 3 81 138 903.000
5 378 3 44 128 2.429.367
5 181 3 100 187 1.143.850
5 166 3 98 183 900.000
5 119 3 100 150 600.000
5 174 3 102 211 2.500.000
5 124 3 103 160 1.103.939
4 112 3 40 56 363.825
4 227 3 69 123 1.538.000
4 161 3 112 213 1.370.968
4 216 3 80 124 1.339.903
3 102 3 53 91 173.481
4 96 3 73 134 210.000
4 97 3 94 120 441.737
4 56 3 70 100 96.000
3 72 3 40 75 177.833
3 62 3 50 90 252.390
3 78 3 70 120 377.182
3 74 3 80 95 111.000
3 33 3 85 120 238.000
3 30 3 50 80 45.000
3 39 3 30 68 50.000
3 32 3 30 100 40.000
2 25 3 32 55 61.766
2 41 3 50 90 166.903
2 24 3 70 120 116.056
2 49 3 30 73 41.000
2 43 3 94 120 195.821
4 9 3 100 180 0
2 20 3 70 120 96.713
2 32 3 19 45 6.500
2 14 3 35 70 5.500
2 14 3 50 80 4.000
1 13 3 25 45 15.000
1 13 3 30 50 9.500
2 53 3 55 80 48.200
3 11 3 95 120 3.000
1 16 3 25 31 27.084
1 21 3 16 40 30.000
1 21 3 16 40 20.000
1 46 3 19 23 43.549
1 21 3 30 40 10.000

In: Statistics and Probability

A standard flashlight battery can deliver about 4.9 W·h of energy before it runs down. (a)...

A standard flashlight battery can deliver about 4.9 W·h of energy before it runs down. (a) If a battery costs 80 cents, what is the cost in dollars of operating a 100 W lamp for 11 h using batteries? (b) What is the cost in dollars if power is provided at the rate of 6.0 cents per kilowatt-hour?

In: Physics

Need to know A and B A. describe in detail the basic structure of a muscle...

Need to know A and B

A. describe in detail the basic structure of a muscle organ.

B. be sure to explain how endomysium, perimysium and epimysium play a role in muscle contraction. Explain how the connect to muscle fibers as well as to the tendon. think of how the tendon runs through the muscle tissue and breaks up into the endo, peri, and epimysium

In: Anatomy and Physiology

A 200 kg weather rocket is loaded with 100 kg of fuel and fired straight up....

A 200 kg weather rocket is loaded with 100 kg of fuel and fired straight up. It accelerates upward at 35 m/s2 for 32 s, then runs out of fuel. Ignore any air resistance effects.

1. What is the rocket's maximum altitude?

2. How long is the rocket in the air before hitting the ground?

In: Physics

In C++ Design and implement a program (name it ProcessGrades) that reads from the user four...

In C++ Design and implement a program (name it ProcessGrades) that reads from the user four integer values between 0 and 100, representing grades. The program then, on separate lines, prints out the entered grades followed by the highest grade, lowest grade, and averages of all four grades. Format the outputs following the sample runs below.

In: Computer Science

***This is done with Java programming*** Write a well-documented (commented) program, “ISBN,” that takes a 9-digit...

***This is done with Java programming***

Write a well-documented (commented) program, “ISBN,” that takes a 9-digit integer as a command-line argument, computes the checksum, and prints the ISBN number.

You should use Java’s String data type to implement it. The International Standard Book Number (ISBN) is a 10-digit code that uniquely specifies a book. The rightmost digit is a checksum digit that can be uniquely determined from the other 9 digits, from the condition that d1 + 2d2 +3d3 + ... + 10d10 must be a multiple of 11 (here di denotes the ith digit from the right).

The checksum digit d1 can be any value from 0 to 10. The ISBN convention is to use the character X to denote 10. The checksum digit corresponding to 032149805 is 4 since 4 is the only value of x between 0 and 10 (both inclusive), for which 10·0 + 9·3 + 8·2 + 7·1 + 6·4 + 5·9 +4·8 +3·0 + 2·5 + 1·x is a multiple of 11.

Sample runs would be as follows.

>java ISBN 013376940
The ISBN number would be 0133769402

>java ISBN 013380780
The ISBN number would be 0133807800

***This is done with Java programming***

In: Computer Science