Question
In: Finance
The following data represent the 2019 monthly sales in units for the Pacific Region Sales Team...
The following data represent the 2019 monthly sales in units for the Pacific Region Sales Team of QualCase, Inc.
|
Month |
Units sold (xi) |
(x – x-bar) |
Squared values |
Divide total by n-1 |
SQRT |
|
Jan |
73 |
| |
| |
||
|
Feb |
79 |
| |
| |
||
|
Mar |
76 |
| |
| |
||
|
Apr |
79 |
| |
| |
||
|
May |
80 |
| |
| |
||
|
Jun |
78 |
| |
| |
||
|
Jul |
77 |
| |
| |
||
|
Aug |
78 |
| |
| |
||
|
Sep |
75 |
| |
| |
||
|
Oct |
72 |
| |
| |
||
|
Nov |
75 |
| |
| |
||
|
Dec |
82 |
V |
V |
||
|
TOTAL => |
TOTAL => |
||||
|
n = |
|||||
|
x-bar = |
PROBLEM #1: Use the table above and the procedures learned in class to calculate the standard deviation (notated as s) of average monthly sales. What is the standard deviation of average monthly sales?
PROBLEM #2: Apply the results of your answer to Problem #1 and use the table below and the procedures learned in class to calculate the 95% confidence interval for average monthly sales in units. What is the 95% confidence interval (CI) for average monthly sales?
|
SE of mean |
|
|
z-value |
1.96 |
|
Plus/minus value |
|
|
Upper CI value |
|
|
Lower CI value |
Solutions
Expert Solution
Answer 1:
Standard deviation of average monthly sales = 2.92
Calculations are as below (format as given is used):
The above excel with 'show formula' is given below:
Answer 2:
As calculated in answer 1 SD of mean monthly sales = 2.92
Plus/minus value = 2.92 * 1.96 = 5.73
Upper CI Valu = 77 + 5.73 = 82.73
Lower CI value = 77 - 5.73 = 71.27
jeff jeffy answered 1 year agoRelated Solutions
Eyad & Ndidi Company reported the following monthly data: Units produced 2,000 units Sales price $...
Eyad & Ndidi Company reported the following monthly data:
Units produced 2,000 units Sales price $ 25 per unit Direct
materials $ 1 per unit Direct labor $ 2 per unit Variable overhead
$ 3 per unit Fixed overhead $ 8,000 in total What is Eyad and
Ndidi's net income under variable costing if 980 units are sold and
operating expenses are $12,000? Question 10 options: $10,620
($1,380) ($2,000) $2,700 $6,620
Decko Industries reported the following monthly data: Units produced 66,000 units Sales price $ 47 per...
Decko Industries reported the following monthly data:
Units produced
66,000
units
Sales price
$
47
per unit
Direct materials
$
2.90
per unit
Direct labor
$
3.90
per unit
Variable overhead
$
4.90
per unit
Fixed overhead
$
235,400
in total
What is the company's contribution margin for this month if 64,000
units were sold?
part b
Kluber, Inc. had net income of $906,000 based on variable
costing. Beginning and ending inventories were 55,600 units and
53,200 units, respectively. Assume...
The data in the table below (and available online) represent monthly gross sales for Ska Brewing...
The data in the table below (and available online) represent
monthly gross sales for Ska Brewing Company from 2009 to
2012. This is real data, let’s help Ska
forecast 2013…
Year
January
February
March
April
May
June
July
August
September
October
November
December
Total
9 9
$193,481
$170,674
$228,095
$232,372
$288,188
$304,763
$337,825
$342,121
$320,011
$304,756
$221,514
$235,591
10
$267,782
$225,592
$356,604
$274,723
$377,369
$439,907
$430,999
$485,822
$407,577
$450,234
$315,238
$345,135
11
$319,313
$323,726
$342,353
$361,315
$612,500
$564,599
$518,422
$623,860
$412,091...
The following data represent the monthly phone use, in minutes, of a customer enrolled in a...
The following data represent the monthly phone use, in
minutes, of a customer enrolled in a fraud prevention program for
the past 20 months. The phone company decides to use the upper
fence as the cutoff point for the number of minutes at which the
customer should be contacted.
446, 363, 488, 329, 468, 304, 444, 459, 336, 415, 403, 542, 473,
448, 531, 355, 451, 547, 465, 334
What is the cutoff point?
The following data represent the monthly phone use, in minutes, of a customer enrolled in a...
The following data represent the monthly phone use, in
minutes, of a customer enrolled in a fraud prevention program for
the past 20 months. The phone company decides to use the upper
fence as the cutoff point for the number of minutes at which the
customer should be contacted. What is the cutoff point?
397
391
401
438
342
518
516
335
301
347
500
388
325
422
510
434
541
303
321
345
The cutoff point is minutes.
Equivalent Units of Production Units of production data for the two departments of Pacific Cable and...
Equivalent Units of Production Units of production data for the
two departments of Pacific Cable and Wire Company for November of
the current fiscal year are as follows: Drawing Department Winding
Department Work in process, November 1 6,900 units, 20% completed
3,600 units, 80% completed Completed and transferred to next
processing department during November 94,500 units 93,200 units
Work in process, November 30 5,200 units, 45% completed 4,900
units, 20% completed a. If all direct materials are placed in
process...
Equivalent Units of Production Units of production data for the two departments of Pacific Cable and...
Equivalent Units of Production
Units of production data for the two departments of Pacific
Cable and Wire Company for November of the current fiscal year are
as follows:
Drawing Department
Winding Department
Work in process, November 1
7,400 units, 45% completed
3,700 units, 65% completed
Completed and transferred to next
processing department during November
101,400 units
100,100 units
Work in process, November 30
5,600 units, 75% completed
5,000 units, 30% completed
a. If all direct materials are placed in
process...
The following data represent the daily supply (y in thousands of units) and the unit price...
The following data represent the daily supply (y in
thousands of units) and the unit price (x in dollars) for
a product.
Daily Supply (y)
Unit Price (x)
5
2
7
4
9
8
12
5
10
7
13
8
16
16
16
6
a.
Compute and interpret the sample covariance for the above
data.
b.
Compute the standard deviation for the daily supply.
c.
Compute the standard deviation for the unit price.
d.
Compute and interpret the sample...
The following data represent x = boat sales and y = boat trailer sales from 1995...
The following data represent x = boat sales and y = boat trailer
sales from 1995 through 2000.
Boats
Trailers
649
207
619
194
596
181
576
174
585
168
574
159
1. Determine the Y intercept of the least-squares regression
line. (Specify your answer to 2nd decimal point)
2.Determine the slope of the least-squares regression line.
(Specify your answer to 3rd decimal point)
3. Based on Q1 and Q2, estimate, for a year during which 500,000
boats are sold,...
Question 1 The following data represent the cost of electricity (in Rand) during July 2019 for...
Question 1 The following data represent the cost of electricity
(in Rand) during July 2019 for a random sample of 30 one-bedroom
apartments in a large city:
96 171 202 178 147 197 130 149 167 191 135 129 158 166 150 95
187 144 139 175 123 111 116 202 157 128 82 102 112 95
(a) Construct a stem and leaf graph for the given data. (10)
(b) Construct a histogram for the given data. (10)
(c) Draw...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Please answer these questions Data Processing and Analysis using python. Thank you In statistics, an outlier...
- Write a function file that accepts each of the four vectors as inputs. The function file...
- Kant says that to act morally is to act out of duty. How does this differ...
- Suppose you are trying to determine the capacity (in gallons) of the gas tank needed on...
- List the arithmetic operators used in BASIC and state their priorities of execution in a statement....
- Describe the espoused values of a company you have worked for (or been exposed to -...
- Can you explain to me the differnces in how we paid for the health care (access...
ADVERTISEMENT