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 |
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) |
PLEASE USE THE BELOW GIVEN DATA TO SOLVE THIS PROBLEM. INCLUDING THE BRIEF REPORT. THANK YOU....
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 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 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 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 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 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 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 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 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 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