Does the forecast vary much from the actual data

Assignment Help Microeconomics
Reference no: EM13277409

Estimate the regression in Estimate by hand calculation the regression equation of the firm's sales revenue (Y) on its quality control expenditure (call it Z) for the data given:
Year (t) 1 2 3 4 5 6 7 8 9 10
Advertising (X1) 10 9 11 12 11 12 13 13 14 15
Quality control (X2) 3 4 3 3 4 5 6 7 7 8
Sales revenue (Y) 44 40 42 46 48 52 54 58 56 60
Z 2 3 4 5 6 7 8 9
Y Forecast
using Excel's regression function in the Data Analysis menu. (b) Using the coefficients found in the regression estimate, enter a formula (based in cells C6 through J6 to forecast the sales revenue when quality control goes from $2 million to $9 million a year. (c) Graph both the actual data and forecast using the graphing tool. Does the forecast vary much from the actual data?

Reference no: EM13277409

Questions Cloud

Find probability that call comes from within 2 km of tower : A cell-phone tower has a circular coverage area of radius 10 km. If a call is initiated from a random point in the coverage area, find the probability that the call comes from within 2 km of the tower.
What is the probability of drawing an ace and a jack : Two cards are drawn at random from a single well-shuffled deck of playing cards. What is the probability of drawing the ace of spades followed by the jack of hearts. What is the probability of drawing an ace and a jack (in either order).
What is the second clarinets frequency : Two musicians are comparing their clarinets. The first clarinet produces a tone that is known to be 442Hz,  If the second clarinet produces a higher pitched tone than the first clarinet, what is the second clarinet's frequency
Calculate vphase primary and secondary-p-q and s : For a transformer with a line voltage of 34.5 KV on the primary and a line voltafe of 480V. Calculate Vphase primary and secondary,P,Q, and S for each of the following transformer connections and loads.
Does the forecast vary much from the actual data : Using Excel's regression function in the Data Analysis menu. (b) Using the coefficients found in the regression estimate, enter a formula (based in cells C6 through J6 to forecast the sales revenue when quality control goes from $2 million to $..
What is the final angular velocity of the disk : A person with mass mp = 70 kg stands on a spinning platform disk with a radius of R = 2.13 m and mass md = 187 kg. What is the final angular velocity of the disk
Total operating revenues of public transportation authority : The total operating revenues of public transportation authority are $100 million while its total operating costs are $120 million. The price of a ride is $1, and the price elasticity of demand for public transportation has been estimated to be..
Find the second moment and the variance of x : An optical communication system employs a photodetector whose output is modeled as a Poisson(λ ) random variable X. Find the second moment and the variance of X.
Find the probability that the aircraft cannot fly : On a certain aircraft, the main control circuit on an autopilot fails with probability p. A redundant backup circuit fails independently with probability q. The aircraft can fly if at least one of the circuits is functioning.

Reviews

Write a Review

Microeconomics Questions & Answers

  Does the forecast vary much from the actual data

Using the coeffficients found in the regression estimate, enter a formula based in cells C6 through J6 to forecast the sales revenue when quality control goes from $2million to $9million a year.

  Explain the long-run perfectly competitive equilibrium

Illustrate with a diagram and explain the long-run perfectly competitive equilibrium for the firm and explain and illustrate using a diagram why a monopolist would never produce in the inelastic range of the demand curve.

  Describe how stimulation could trigger runaway inflation

those polices were predicated on 1930s Keynesian assumptions that economic recoveries always run out of steam and at certain points need artificial stimulation of demand and fine-tuning to keep them running at acceptable levels .The evidince of th..

  Determine one possible combination of government spending

Assume that a hypothetical economy with an MPC of 0.75 is experiencing a severe recession. 1. By how much would government spending have to rise to shift the aggregate demand curve rightward by $50 billion 2. How large a tax cut would be needed to ac..

  Describe labor supply growth

Pass laws prohibiting children from working in labor market X. Require a license to work in labor market X. Increase tariffs on imports that compete with labor market X employers.

  Who wins the price war

Consider a firm selling two products, A and B, that substitute for each other. Suppose that an entrant introduces a product that is identical to product A. What factors do you think will affect (a) whether a price is initiated, and (b) who wins t..

  Which of the families in the city will buy their shirts

Jim enters the town and makes a factory, which is employed by the locals. Every worker in the factory works on one machine and is able to produce 6 shirts per hour. The cost of running the machine is half a loaf of bread per hour, the cost to empl..

  Concept of derived demand

One way to view the law of diminishing marginal productivity is to say that, The concept of derived demand can best be illustrated by the statement:

  How to approach to pricing pharmaceutical products

The pharmaceutical industry often has the luxury of implementing pricing strategies that appear high to consumers. Take a position on the fairness of the industry's approach to pricing pharmaceutical products including offering an alternative stra..

  What describes the monopolistic competition

A monopolist is maximizing profit at an output rate of 1,000 units per month. At this output rate, the price that its customers are willing and able to pay is $8 per unit, average total cost is $5 per unit, and marginal cost is $6 per unit. It may..

  Virtual mcos-natural remedies-personal responsibility

Explain what could happen in the future with each of these trends below and come up with three(3) more trends not listed and do the same analysis for your three additions.

  What political forces help prevent the more widespread

Currently, it is difficult to sue the federal goverment unless it agrees to be sued. If the law were changed so that lawsuits (such as by victims of the collapse of the I-35W bridge) were easier, how would this change the incentives of the goverme..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd