Question

PLEASE USE THE BELOW GIVEN DATA TO SOLVE THIS PROBLEM. INCLUDING THE BRIEF REPORT.

THANK YOU.

Sales (Y) Calls (X1) Time (X2) Years (X3) Type
47 167 12.9 5 ONLINE
47 167 16.1 5 ONLINE
44 165 14.2 5 GROUP
43 137 16.6 4 NONE
34 184 12.5 4 GROUP
36 173 14.3 4 GROUP
44 160 14.1 4 NONE
34 132 18.2 4 NONE
48 182 14.1 4 ONLINE
41 158 13.8 4 GROUP
38 163 10.8 4 GROUP
53 183 11.4 4 ONLINE
39 148 14.4 4 GROUP
48 164 14.7 3 NONE
46 182 13.2 3 ONLINE
34 122 20.4 3 NONE
30 175 14.3 3 GROUP
38 145 15.6 3 NONE
43 164 13.1 3 ONLINE
40 148 15.2 3 GROUP
46 161 16.6 3 ONLINE
42 153 14.9 3 GROUP
39 181 14.7 3 ONLINE
48 163 15.5 3 GROUP
45 152 17.1 3 GROUP
39 147 13.6 3 GROUP
44 133 19.2 3 GROUP
47 166 13.8 3 ONLINE
37 192 13.7 3 ONLINE
42 154 13.6 3 ONLINE
40 135 19.5 3 GROUP
45 155 11.6 3 GROUP
33 164 15.9 3 ONLINE
42 160 16.5 3 GROUP
38 142 17.9 3 NONE
42 183 14.4 2 ONLINE
51 183 11.4 2 ONLINE
44 136 17.2 2 GROUP
40 201 13.1 2 ONLINE
39 127 17.1 2 ONLINE
35 188 18.2 2 ONLINE
47 173 14.6 2 ONLINE
52 187 12.5 2 ONLINE
43 150 15.3 2 GROUP
41 133 15.9 2 NONE
40 158 15.6 2 ONLINE
52 181 11.8 2 ONLINE
41 138 16.1 2 NONE
37 171 11.7 2 GROUP
47 174 13.8 2 GROUP
40 146 18.2 2 GROUP
50 162 15.6 2 ONLINE
48 152 19.9 2 ONLINE
44 174 18.5 2 GROUP
46 170 14.2 2 ONLINE
41 155 14.8 2 GROUP
37 163 14.4 2 ONLINE
49 181 11.6 2 NONE
40 139 15.7 2 NONE
36 162 18.4 2 ONLINE
42 148 13.7 2 NONE
41 147 16.8 2 GROUP
51 193 12.1 2 ONLINE
35 149 19.3 2 NONE
49 187 14.3 2 ONLINE
37 128 19.7 2 NONE
46 174 16.6 2 GROUP
46 160 12.9 1 GROUP
46 148 15.5 1 GROUP
39 131 18.4 1 GROUP
43 153 17.3 1 NONE
44 145 15.8 1 NONE
40 132 12.8 1 NONE
48 191 13.6 1 GROUP
41 137 16.7 1 NONE
38 127 18.5 1 GROUP
38 139 12.2 1 NONE
34 160 13.1 1 ONLINE
36 158 17.5 1 GROUP
50 172 11.1 1 ONLINE
40 192 12.7 1 ONLINE
41 148 14.8 1 GROUP
45 165 16.4 1 GROUP
53 174 15.1 1 ONLINE
52 175 12.3 1 NONE
37 189 12.7 1 ONLINE
36 204 12.1 1 ONLINE
45 151 13.6 1 GROUP
45 153 13.4 1 GROUP
41 173 15.4 1 ONLINE
44 144 15.3 0 GROUP
45 148 16.3 0 ONLINE
41 120 17.7 0 NONE
43 164 15.2 0 ONLINE
48 142 14.8 0 NONE
43 173 12.8 0 ONLINE
48 173 17.4 0 ONLINE
42 191 14.2 0 ONLINE
45 152 21.8 0 ONLINE
48 169 14.8 0 ONLINE

Complete the following four hypotheses, using a 0.05 for each a. Mean sales per week exceeds 41.5 per salesperson b. Proporti

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

One-Sample T: Sales (Y)

Descriptive Statistics

N Mean StDev SE Mean
100 42.620 5.037 0.504

μ: mean of Sales (Y)

Test

Null hypothesis H₀: μ = 41.5
Alternative hypothesis H₁: μ > 41.5
T-Value P-Value
2.22 0.014

p-value is lesser than 0.05 we reject null hypothesis.

Test and CI for One Proportion

Method

p: event proportion
Normal approximation method is used for this analysis.

Descriptive Statistics

N Event Sample p 95% Upper Bound
for p
100 42 0.420000 0.501183

Test

Null hypothesis H₀: p = 0.55
Alternative hypothesis H₁: p < 0.55
Z-Value P-Value
-2.61 0.004

p-value is lesser than 0.05 we reject null hypothesis.

One-Sample T: Calls (X1)

Descriptive Statistics

N Mean StDev SE Mean 95% Lower Bound
for μ
100 160.43 19.13 1.91 157.25

μ: mean of Calls (X1)

Test

Null hypothesis H₀: μ = 145
Alternative hypothesis H₁: μ > 145
T-Value P-Value
8.07 0.000

p-value is lesser than 0.05 we  reject null hypothesis.

One-Sample T: Time (X2)

Descriptive Statistics

N Mean StDev SE Mean 95% Lower Bound
for μ
100 15.107 2.344 0.234 14.718

μ: mean of Time (X2)

Test

Null hypothesis H₀: μ = 15
Alternative hypothesis H₁: μ > 15
T-Value P-Value
0.46 0.325

p-value is lesser than 0.05 we fail to reject null hypothesis.

2) 95 % CI

Mean sales

95% CI for μ
(41.621, 43.619)

Oline training

95% CI for p
(0.323264, 0.516736)

Mean calls

95% CI for μ
(156.63, 164.23)

Time

95% CI for μ
(14.642, 15.572)
Add a comment
Know the answer?
Add Answer to:
PLEASE USE THE BELOW GIVEN DATA TO SOLVE THIS PROBLEM. INCLUDING THE BRIEF REPORT. THANK YOU....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need help with my applied managerial statistics project Do a descriptive analysis(calculate mean, mode ,range...

    I need help with my applied managerial statistics project Do a descriptive analysis(calculate mean, mode ,range ,variance ,std ,deviation etc ) on each of the four variables sales ,calls, time, years and plot a histogram (using Excel)for each of the four variables. B Sales (Y) 37 38 40 117 45 43 34 37 137 138 44 45 37 38 43 46 45 Calls (X1) Time (X2) Years (X3) 117 14.8 117 15.3 15.6 117 15.8 120 18.2 120 13.6 131...

  • 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...

  • These are my instructions: Your data should have been read in from the data file and stored into ...

    These are my instructions: Your data should have been read in from the data file and stored into an array. Next you need to calculate the following and display in a single Message box: Average score Highest score Lowest score Mode of the scores Your program should be written using methods and should be well documented internally and externally. Your output should be displayed using Message boxes. This is the .text file to use with the instructions: 20 21 22...

  • Sample Data Sample Data Hour Sample Taken Hour Sample Taken 1 4 5 X 1 3...

    Sample Data Sample Data Hour Sample Taken Hour Sample Taken 1 4 5 X 1 3 1 42 2 3 4 5 6 2 39 36 25 60 28 53 22 56 41 34 43 45 59 42 36 40 45 39 48 26 42 34 61 48 45 29 3 31 61 38 40 54 26 38 42 37 41 53 37 47 41 37 29 20 26 43 38 33 37 37 35 33 36 41 25 37...

  • The data file below contains a sample of customer satisfaction ratings for XYZ Box video game...

    The data file below contains a sample of customer satisfaction ratings for XYZ Box video game system. If we let µ denote the mean of all possible customer satisfaction ratings for the XYZ Box video game system, and assume that the standard deviation of all possible customer satisfaction ratings is 2.64: Ratings 39 45 38 42 42 41 38 42 46 44 40 39 40 42 45 44 42 46 40 47 44 43 45 45 40 46 41 43...

  • The Table 1.8 presents the satisfaction ratings for the XYZ-Box video game system that have been...

    The Table 1.8 presents the satisfaction ratings for the XYZ-Box video game system that have been given by 65 randomly selected purchasers. Figure 2.15 gives the Excel output of a histogram of these satisfaction ratings. ata (a) Where do the satisfaction ratings seem to be concentrated? (Click to select) (b) Based on part(a), the shape of the distribution of ratings is Click to sclect (c-d) Construct a cumulative frequency distribution of the satisfaction ratings using the histogram classes. (Leave no...

  • Do the Academy Awards involve discrimination based on age? Listed below are the ages of actresses...

    Do the Academy Awards involve discrimination based on age? Listed below are the ages of actresses and actors at the times that they won Oscars in the Best Actress and Best Actor categories. the ages are listed in order, beginning with the first Academy Awards ceremony in 1928. (Note: in 1968 there was a tie in the Best Actress category, and the mean of the two ages is used; in 1932 there was a tie in the Best Actor category,...

  • Solve all parts and show working: (i) : Use a 5% significance level to test the...

    Solve all parts and show working: (i) : Use a 5% significance level to test the claim that the unsuccessful applicants are from a population with a greater mean age than the mean age of successful applicants. Based on the result, does there appear to be discrimination based on age? What did you use to get the answer? (ii): Is it a parametric or non-parametric test? If it is a parametric test what is distribution of test statistic The Revenue...

  • Consider the sample of 60 bottle design ratings given in the table (below). A Sample of...

    Consider the sample of 60 bottle design ratings given in the table (below). A Sample of Bottle Design Ratings (Composite Scores for a Systematic Sample of 60 Shoppers) 48 46 37 47 38 50 35 48 35 48 47 39 49 52 48 37 39 52 50 39 36 39 38 37 46 39 51 37 50 41 36 36 45 45 50 39 49 49 39 36 45 39 52 44 47 46 49 39 39 43 41 52...

  • 37 38 39 Question 51 (1 point) Below are shown three structures for Carvone, a substance...

    37 38 39 Question 51 (1 point) Below are shown three structures for Carvone, a substance responsible for the odor of spearmint. Which one of the structures is a line structure? 40 41 42 HH CHH CH2 43 44 45 C-CC-CC-0 CH HC Hн. 46 47 48 (C-H "CH₂ H1 HHH B 49 50 51 Carvone 52 53 54 ✓ 55 56 B ✓ None of the above

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT