Question

In: Statistics and Probability

Question 1 Office Support, Inc. provides on-site repair for most large photocopy machines. It currently has...

Question 1

Office Support, Inc. provides on-site repair for most large photocopy machines. It currently has five trained repair teams that it sends out on an on-call basis. Since the company advertises one-day service, it will not accept more than five requests for service per day. Two months ago, the vice president started considering expanding the workforce. At that time he asked the call desk to record the actual calls for each of the next 40 days. The data to respond to the questions below are provided in the Office worksheet. Define the random variable x as the number of service calls per day.   Clearly x is a discrete random variable.

4 points: Use built-in Excel functions to find the minimum and maximum values of x. That is, find the minimum number and maximum number of service calls per day over the 40 day period.   

Place the minimum in cell E2.

Place the maximum in cell E3.

4 points: Based on the minimum and maximum number of service calls per day in the sample of 40 days, specify the complete range of x. That is, make a list of all possible outcomes of x under the column labeled x starting in cell G2.

9 points: Using the built-in Excel function named COUNTIF, calculate the count (frequency) of each outcome (x) in the sample. In general, your function with its arguments will appear as
“=COUNTIF(argument 1, argument 2),” where argument 1 is the data range and argument 2 is a cell reference containing a specific outcome value. Start by finding the count for x = 0, then finding the count for all other outcomes. The values will be under the column labeled “Count.”

In the first unused cell following the last count value (from above), use Excel’s built-in SUM function to calculate the total count (frequency). For example, if the count cells went from H2:H7, enter the sum in cell H8. Format the sum cell (box, color, etc.) to highlight that it contains the sum of the values above it.

Day Number of Service Calls Range of x Value 1a x Count P(x)
1 2 Min(x) = 0 1
2 1 Max(x) = 6 2
3 3 3
4 2 4
5 4 5
6 3 6
7 2
8 0 E(x) = Var(x) =
9 5 StdDev(x) =
10 2 Grader
11 5 1b
12 3 1c
13 4 1d
14 2 1e
15 6 1f
16 1 1g
17 0 1h
18 3
19 5
20 2
21 4
22 3
23 5
24 1
25 5
26 2
27 2
28 4
29 3
30 6
31 2
32 4
33 0
34 4
35 5
36 1
37 3
38 4
39 2
40 3

Solutions

Expert Solution

Range of x Value
Min(x) = 0
Max(x) = 6
Day Number of Service Calls Range of x Value 1a x Count P(x)
1 2 Min(x) = 0 0 3 0.075 0
2 1 Max(x) = 6 1 4 0.1 0.1
3 3 2 10 0.25 0.5
4 2 3 8 0.2 0.6
5 4 4 7 0.175 0.7
6 3 5 6 0.15 0.75
7 2 6 2 0.05 0.3
8 0 E(x) = 2.95 Var(x) = 2.55
9 5 StdDev(x) = 1.60
10 2 Grader
11 5 1b
12 3 1c
13 4 1d
14 2 1e
15 6 1f
16 1 1g
17 0 1h
18 3
19 5
20 2
21 4
22 3
23 5
24 1
25 5
26 2
27 2
28 4
29 3
30 6
31 2
32 4
33 0
34 4
35 5
36 1
37 3
38 4
39 2
40 3

Related Solutions

Watson & Watson Repair Inc. provides maintenance service for a large apartment complex in downtown Saint...
Watson & Watson Repair Inc. provides maintenance service for a large apartment complex in downtown Saint Petersburg, Florida. The managers are evaluating the possibility of hiring another maintenance person due to the increase of maintenance calls. Rafael Roddick and Andy Nadal are currently responsible for maintenance tasks. To investigate “what” drives Repair Time and be able to hire the best candidate, the managers hire you as statistician to conduct a regression analysis. As dependent variable you have time of repair...
Modern Office Solutions Inc. leases most of its office furniture and equipment. On January 1, 2020,...
Modern Office Solutions Inc. leases most of its office furniture and equipment. On January 1, 2020, Modern entered into a five-year lease for new equipment. The payments are to be made at the beginning of each lease year. Modern has the option of purchasing the equipment at the end of the lease. The present value of the minimum lease payments is equal to the fair value of the equipment at lease inception. Modern follows IFRS. Other information is as follows:...
QUESTION 1 Abang Berhad, located in Jitra, Kedah provides automobile repair service. Abang Berhad conducts the...
QUESTION 1 Abang Berhad, located in Jitra, Kedah provides automobile repair service. Abang Berhad conducts the following business activities for the month of February 2020. Date Description February 1 Issued invoice of RM40,000 to Orang Berhad for repair services rendered for its fleets of cars. February 4 Received quotation of RM25,000 for office supplies. February 8 Purchased office supplies of RM15,000 on account from Boniface Berhad February 12 Received RM30,000 from Orang Berhad representing 75% payment of amount owned on...
Question #1. Humongous Inc. is a large publicly traded manufacturer of health care products. It has...
Question #1. Humongous Inc. is a large publicly traded manufacturer of health care products. It has a reputation as oneof the best-managed companies in the U.S.A. However, the company recently came under fierce criticismby the government for charging exorbitant prices to consumers.Investors have responded negatively tofears that the government would reform the health care sector and make an attempt to reign in prices. As a result of these fears, Humongous’s stock price lost 30% of its value in the past...
QUESTION 1 Most of the water and inorganic ions are absorbed by the: large intestine. small...
QUESTION 1 Most of the water and inorganic ions are absorbed by the: large intestine. small intestine. stomach. large and small intestines. large intestine, small intestine, and stomach. QUESTION 2 In order to transport __________ into the bloodstream from the small intestine, a ________ is established in the epithelial cells lining the small intestine. ions; glucose acetyl-coA; calcium glucose; sodium sodium; glucose
Question 4 a) The rate at which computer technology is currently advancing has resulted in most...
Question 4 a) The rate at which computer technology is currently advancing has resulted in most new computers becoming obsolete in only two to three years after they have been purchased. Discuss the impact of such electronic equipment on the environment suggest possible solutions as to how they should be disposed. AP 8 b) Access to internet and information technology has created a gap between social classes. Explain the policies and programmes you should be put in place in order...
Conference Services Inc. has leased a large office building for $4 million per year. The building...
Conference Services Inc. has leased a large office building for $4 million per year. The building is larger than the company needs: two of the building's eight stories are almost empty. A manager wants to expand one of her projects, but this will require using one of the empty floors. In calculating the net present vlaue of the proposed expansion, upper management allocates one-eighth of $4 million of building rental costs (i.e., $.5 million) to the project expansion, reasoning that...
1. AirQual Test Corporation provides on-site air quality testing services. The company has provided the following...
1. AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: Fixed Component per Month Variable Component per Job Actual Total for February Revenue $ 278 $ 38,950 Technician wages $ 8,500 $ 8,350 Mobile lab operating expenses $ 4,600 $ 32 $ 9,240 Office expenses $ 2,500 $ 2 $ 2,650 Advertising expenses $ 1,600 $ 1,670 Insurance $ 2,900 $ 2,900 Miscellaneous expenses...
In this question, we will explore the irrelevance of dividend policy. Suppose XYZ Inc currently has...
In this question, we will explore the irrelevance of dividend policy. Suppose XYZ Inc currently has 1 million shares outstanding, and XYZ expects to make $1 million per year in perpetuity, all of which is paid out in dividends. Assume the relevant discount rate is 10%. (Ignore taxes and transaction costs, and assume the markets are efficient.Use the DDM to value the shares) a.What is the value of one share of XYZ Inc? (Assume the next dividend payment is one...
Question 1 Orange, Inc. is currently a market leader in biomedical test equipment, but the firm’s...
Question 1 Orange, Inc. is currently a market leader in biomedical test equipment, but the firm’s future has never been more uncertain, as it is contemplating two projects that fall into the “unchartered waters” category. The CEO, Tim Jobless, who also owns 50.1% of the firm’s 1 million outstanding shares, often disagrees with the rest of the shareholders. The first project under evaluation is production of the ePhone, a smartphone that is more smart than phone. Its marketing department has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT