The following table shows the number of cell phone minutes used per month on my family plan

Question:

The following table shows the number of cell phone minutes used per month on my family plan for the past eight months. These data can also be found in the Excel file cell phone minutes.xlsx.

Month 1 2 3 4 5 6 7 8 Minutes 325 355 326 433 390 414 447 440

a. Construct a graph showing the number of minutes used per month on my cell phone account over time.

b. Forecast the number of minutes for next month using a trend projection.

c. Calculate the MAD for this forecast.

d. If my family plan includes only 500 minutes per month, in what month am I predicted to exceed these minutes?

AppendixLO1

Step by Step Answer:

Related Book For book-img-for-question

Business Statistics

ISBN: 9780133852288

2nd Edition

Authors: Robert A Donnelly, Robert Donnelly Jr

See More Books

Question Posted: Jul 10, 2024 09:01 AM

See More Questions

The following table shows the number of cell phone minutes used per month on my family plan for the past eight months. These data can also be found in the Excel file cell phone minutes.xlsx. a....
Complete the following problems from Chapter 12 in Financial Management: Theory and Practice : Chapter 12: Topics: Additional Funds Needed, Forecasted Statements and Ratios, Financing Deficits...
I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...
Ridge Crest Company has beginning Retained Earnings of $39,000, ending Retained Earnings of $41,500, and a net income of $23,500. What was the amount of dividends declared during the year: $15,500...
A mail-order company promises its customers that the products ordered will be mailed within 72 hours after an order is placed. The quality control department at the company checks from time to time...
Draw a figure to illustrate the Intel-AMD Nash-Cournot equilibrium in Solved Problem 13.2. At what quantities do the best-response functions hit the axes?
Todd and Carlo became partners on January 1, 2005, in their joint venture ToLo Sports Bar. Todd put in $50,000, while Carlos share was $75,000. The net income for the year is $12,000. If the income...
Sung Corporation, a manufacturer of steel products, began operations on October 1, 2016. Sung's accounting department has begun to prepare the capital asset and depreciation schedule that follows....
XYZ Inc. has this information for two levels of monthly volume. XYZ Inc. makes one item. Production volume DM 7,800 units $80.90 per unit $52.20 per unit $74.30 per unit 8,800 units $ 80.90 per unit...
Julie owns 100 shares of Apple stock (lucky her) and is trying to decide how much her portfolio will be worth next month. The data in the Excel file Apple stock price. xlsx show the closing price of...
Steve, who has been working hard to improve his golf game, has seen some improvement in his scores over the summer. He would like to use forecasting to set a goal for his next round. The following...
Assume lim x1 f(x) = 8, lim x1 g(x) = 3, and lim x1 h(x) = 2. Compute the following limits and state the limit laws used to justify your computations. lim x1 (4f(x))
A year-end cut-off error occurred in 2017. A large shipment of nonperishable supplies arrived from South America on the last day of 2017 and had been left in the shipping containers outside the main...
15. [5] It's not so difficult to incorporate time-varying volatility into the BSM model as long as the time variation is not random. Assume a BSM economy, but this time, assume that the volatility of...
3.6. Explain and discuss the potential benefits to be gained by using blade twist, plan- form taper, low solidity, large radius, and low rotational speed for the main rotor of a heavy lift helicopter...
2. A VRM (Voltage Regulator Modul) is used to supply the voltageto the CPU of a computer. In the new generation of microprocessors,whose power consumption is 100W, the input voltage to the VRM is12V...
Alvarado Company produced 6,400 units of product that required 5.5 standard direct labor hours per unit. The standard variable overhead cost per unit is $5.80 per direct labor hour. The actual...
A 2.5-m-long wire having a mass of 0.10 kg is fixed at both ends and is under tension of 30 N. When the nth harmonic is excited, there is a node 0.50 m from one end. (a) What is n? (b) What are the...
Describe basic managerial approaches to implementing controls and how these are implemented.
4 Exercise 9-6 (Algo) Lower of cost or market [LO9-1) 75 Tatum Company has four products in its inventory. Information about the December 31, 2021, Inventory is as follows: oints Product Total Cost...
A real estate investment is expected to return to its owner $3,500 per year for 16 years after expenses. At the end of year 16, the property is expected to be sold for $49,000. Assuming the required...
You borrowed $15,000 for buying a new car from a bank at an interest rate of 12% compounded monthly. This loan will be repaid in 48 equal monthly installments over four years. Immediately after the...

The following table shows the number of cell phone minutes used per month on my family plan

Question:

Step by Step Answer:

This question has not been answered yet.

Business Statistics

Students also viewed these Business questions