Remove all insignificant variables and re-estimate the model

Assignment Help Basic Statistics
Reference no: EM131614142

Task 1 -

The data for Task 1 in the data file for Assignment represents the starting costs in thousands of dollars) for different kind of business.

1. Find mean, median, mode, range, variance and standard deviation separately for every type of business.

2. For every business type construct

a. frequency and relative frequency distributions starting from class 0 to 30.

b. a relative frequency histogram.

3. Discuss the results obtained in parts 1 and 2.

4. Test if there significant difference in the starting costs for these types of business.

Task 2 -

The data for Task 2 in the data file for Assignment represents the following variables for franchisees of All Greens Pty Ltd: annual sales ($'000), the floor area (sq.ft.'000), inventory ($'000), advertising expenditure ($1000), the size of the area where the business operates (number of families, '000) and the number of competitors in the area.

1. Present the MS Excel output and write down the estimated regression equation.

2. How well the model fits the data?

3. Test the hypothesis that there is no significant relationship between the dependent and any of the independent variables.

4. Interpret individual slope coefficients.

5. Construct a 95% confidence interval for the slope coefficients of individual variables.

6. Test the estimated slope coefficients for individual variables for significance.

7. Remove all insignificant variables and re-estimate the model.

8. Using the model from part (g), predict annual sales for a franchisee with 1,000 sq ft floor area, $150,000 inventory, $5,000 spent on advertising, 5,000 families in the area of operation and 2 competitors.

Attachment:- Data.rar

Verified Expert

This task provides a clear working example on descriptive statistics and multiple regression analysis. Annual sales was taken as the dependent variables and the variables such as floor area, advertising expenses, inventory, size of the area and number of competitors are taken as independent variable. the reliability of the model is very high in predicting the dependent variable annual sales

Reference no: EM131614142

Questions Cloud

Have we chosen the right employee : Once an organization has recruited candidates and they are going through the application process, how do they select the right employee?
Define defendants and victims : A crime resulting in the death of or severe injury to the victim can have a profound impact on a spouse
Find the price of the beef : The quantity, Q, of beef purchased at a store, in kilograms per week, is a function of the price of beef, b, and the price of chicken, c.
The company or organization where the conflict exists : Create a 15- to 20-minute oral presentation that you would give to sell your program to the company or organization where the conflict exists.
Remove all insignificant variables and re-estimate the model : Test the estimated slope coefficients for individual variables for significance. Remove all insignificant variables and re-estimate the model
Creative environment at vibram : Some Virbram employees might be discouraged by counterfeiters, feeling that the innovations they worked hard to create are being stolen too quickly.
What is the relation between pq × pr : Let P = (x, y, z) , Q = (u, v, w) and R = (r, s, t) be points on the plane ax + by + cz = d.
Define juvenile court systems and adult court systems : What are the key differences between the juvenile court systems and adult court systems, to include the differences in courtroom vernacular.
Articulate the null hypothesis and alternative hypothesis : Specify a research question related to gpa and final.Articulate the null hypothesis and alternative hypothesis.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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