Determine the best-fitting regression equation

Assignment Help Basic Statistics
Reference no: EM13895099

1. Use the following Minitab output to determine the best-fitting regression equation for these data

2. What percentage of the total variation in the number of rush returns(y) is explained by this equation?

3. For this year, the economic index (x1) is 169, the population within 1 mile of the office (x2) is 10,212, and the average income in Ithaca (x3) is 26,925. How many rush returns should Pam expect to process?

Pam Schneider owns and operates an accounting firm in Ithaca, New York. Pam feels that it would be useful to be able to predict in advance the number of rush income-tax returns during the busy March 1 to April 15 periods so that she can better plan her personnel needs during this time. She has hypothesized that several factors may be useful in her prediction. Data for these factors and number of rush a return for past years are as follows:

X1 X2 X3 y[Number of rush
[Economic [Population within 1 [Average Income Returns, March 1 to April 15]
Index] mile of office] In Ithaca]

99 10188 21465 2306
106 8566 22228 1266
100 10557 27665 1422
129 10219 25200 1721
179 9662 26300 2544

a) Use the following Minitab output to determine the best-fitting regression equation for these data:

The regression equation is

Y = -1275 + 17.1 x1 + 0.541 x2 - 0.174x3

Predictor Coef Stdev t-ratio p

Constant -1275 2699 -0.47 0.719

x1 17.059 6.908 2.47 0.245

x2 0.5406 0.3144 1.72 0.335

x3 -0.1743 0.1005 -1.73 0.333

s = 396.1 R-sq = 87.2%

b) What percentage of the total variation in the number of rush returns(y) is explained by this equation?

c) For this year, the economic index (x1) is 169, the population within 1 mile of the office (x2) is 10,212, and the average income in Ithaca (x3) is 26,925. How many rush returns should Pam expect to process?

Reference no: EM13895099

Questions Cloud

Explain the benefits and limitations of developing software : You will be asked to demonstrate how your algorithm works and explain the benefits and limitations of developing software solutions to common problems such as that in the scenario.
Brinkley company, which began operations on january : Brinkley Company, which began operations on January 3, 2013, had the following subsequent transactions and events in its long term investments.
What advice do you give ace ventura : Sam made alternative promises to Jill as consideration for her services. Sam was able to choose between the two alternatives, yet a valid contract was fHe is set to represent the Navy in Stockholm next week and knows the President and CEO of WD wi..
How your management practices characteristic will impact : Explain how this characteristic will impact: The skill level required for your employees, The number of employees you will need,  Your management practices and Your criteria for hiring employees.
Determine the best-fitting regression equation : 1. Use the following Minitab output to determine the best-fitting regression equation for these data 2. What percentage of the total variation in the number of rush returns(y) is explained by this equation?
Corporation with customers in several foreign countries : Datamix, a U. S. corporation with customers in several foreign countries, had the following selected trans actions for 2013 and 2014.2013
Scientific progress and cultural advancement : What is the definition of scientific progress and how does it relate to cultural advancement? and Writer Ziauddin Sardar is quoted: The conventional (Western) history of science... does not recognize different types of civilization or cultural scienc..
Explain business consequences if you debit customer credit : Explain the business consequences if you debit customer credit in step 1, but then in steps 2 or 3 do not return credit for orders that you cannot process.
Multiple regression computer output : Below is a partial multiple regression computer output based on a quadratic regression model to predict student enrollment at a local university.

Reviews

Write a Review

Basic Statistics Questions & Answers

  It has been reported that men are more likely than women

it has been reported that men are more likely than women to participate in online auctions. in a recent survey 65 of

  Probability selected cell phone bill is between given value

Suppose local monthly cell phone bills are normally distributed with a standard deviation $12. What is the probability that a randomly selected cell phone bill is between $30 and $55?

  Basic statistics-probability

Pizza House offers 4 different salads, 5 different kinds of pizza, and 4 different desserts. How many different three course meals can be ordered?

  Find the profit-maximizing prices

Assume that demand for services per period is Pt = 1000 - Qt where Qt is the stock of the durable consumed. Let the discount factor for consumers and the firm be given by δ. Find the profit-maximizing prices and outputs for a durable goods monopol..

  Estimate the expected value

One state lottery has 1000 prizes of $1, 200 prizes of $5, 50 prizes of $25, 15 prizes of $150, 4 prizes of $500, and 1 prize of $2500.  What is the lottery expected profit per ticket?

  The random variable x has a poisson distribution with mean

the random variable x has a poisson distribution with mean 40. give an approximate value of the probability p 37 less

  Computing anova and chi square test

A study regarding the relationship between age and the amount of pressure sales personnel feel in relation to their jobs revealed the following sample information.

  The random variable x has the following probability

The random variable x has the following probability distribution.

  Information about scatter plot-regression

In a study about postage tariffs and revenue, the European Economic Community wanted to look at the relationship between the number of postal employees in a country and the amount of domestic mail that was processed. They collected data for six di..

  Suppose these 2 million tests were done on a variety of

according to a newspaper report in 2 million lie detector tests 300000 were estimated to have produced erroneous

  Decide market the new product-expected value approach

Use the expected value approach to decide whether to market the new product. Because of the high dollar values involved, especially the possibility of a $100,000 loss.

  What fraction of employees cost more for dental expenses

Estimate the percent that did not have any dental expense. What was the cost for the 10 percent of employees who incurred the highest dental expense?

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