Share
Explore BrainMass

Regression Analysis

Statistics: Auto parts distributor will estimate annual sales in April

See the attached file. Suppose that the sales manager of a large automotive parts distributor wants to estimate as early as April the total annual sales of a region. On the basis of regional sales, the total sales for the company can also be estimated. If, based on past experience, it is found that the April estimates of annu

Quantitative Reasoning, Excel plotting:Wages,Baseball, Retire

Problem 1 - The following table gives the median weekly earnings of full-time wage and salary workers 25 years and older who have had one to three years of college ... Problem 2 - Refer to the Baseball 2002 data, which reports information on the 30 Major League Baseball teams for the 2002 season. These data are located in .

Regression Analysis: 4 Steps for Benefits and Job Satisfaction

First run a regression analysis using the benefits column of all data points in the data set as the independent variable and the intrinsic job satisfaction column of all data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation? What

Carpet City: Develop a linear regression model

Carpet City wants to develops a means to forecast it carpet sale. The store manager believes that the store's sale are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales. Monthly Carpet Sa

Job Satisfaction - A Statistical Survey and Regression Anaylsis in EXCEL

Prepare a report using Excel as your processing tool to process three simple regression analyses. 1. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent va

A. Develop a linear regression for these data and forecast carpet sales if 30 construction permits for a new homes are filed. B. Determine the strength of the casual relationship between monthly sales and new home construction by using correlation.

24. Carpet city wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales. These data are

Statistics: develop and assess a forecasting model for ice cream production

The Bee line Café is well known for its popular homemade ice cream, which it makes in a small plant in back of the café. People drive long distance to buy the ice cream. The two ladies who own the café want to develop a forecasting model so they can plan their ice cream production and determine the number of employees they n

Statistics Discussion: Common trend models; centered to moving average method

DQ3: (a) Name two advantages and two disadvantages of each of the common trend models (linear, exponential, quadratic). Explain! (b) When would the exponential trend model be preferred to a linear trend model? Explain! DQ4: One of the methods that is used to moderate (smooth) the peaks and valleys within a ti

Regression analysis in SPSS

Use the data set supplied (hypertension, diabetes, cholesterol in subjects, including medication, weight, age, etc) in doc sharing and using SPSS, provide the following for the variable(s) of your choice: 1. Frequency distribution of a variable and bar graph of the same variable 2. Descriptive of a continuous : mean, median,

Statistics

Please notice that we need to calculate the parameters in the linear equations through statistics and not through the mathematics [in Q1 & Q3]. Y= ax + b: here a and b must be calculated through statistical formaula and the steps must be shown. It is not accepted to just plot the data in Excel and fit a stright line to them t

MULTIPLE REGRESSION MODEL

The Westar hotel, a 250 room business hotel has 2 lounges on its premises: Pour Nous Lounge (for 50 people)and Gaisete - for 200. We need to forcast beverage sales. Should we take into consideration season promotional food offered during happy hour, and the presence of a piano player in Pour Nous Lounge.Room occupancy is a fact

Multiple Regression Analysis

Problem: The demand for airplane passengers (Y) is a function of a average fare (X1), the fare of the competing airline, and the annual per capital income of the passengers(X3) Passenger seat sold Fare of the Fare of the competing Annual Per Capital of the airline airline a

Rate of Return

1. If the daily stock price, x, of United Technology is normally distributed with mean 6.56 and standard deviation 2.4, calculate the probability that in a randomly selected ay the price will be between $3.25 and $7.36. Hint: Review normal distribution. 2. An industry is comparing its performance against an industry benchmar

Linear Regression and Correlation: Confidence Interval for Mean

1. The following sample observations were randomly selected. X: 4, 5, 3, 6, 10 Y: 4, 6, 5, 7, 7 a. Determine the regression equation. b. Determine the value of Y' when X is 7. c. Determine the standard error of estimate. d. Suppose a large sample is selected (instead of just 5). About 68% of the prediction

Seafood restaurant

The manager of a seafood restaurant was asked to establish a pricing policy on lobster dinners. Experimenting with prices produced the following data: Average Number Sold per Day, y Price, x 200 $6.00 190

Megastat Regression Analysis: Example Problems

Use Megastat (and show all steps) to solve the following problem: a) Plot the data on U.S. general aviation shipments (see attachment for data). b) Describe the pattern and discuss possible causes. c) Would a fitted trend be helpful?

Correlation and regression: key informaiton

Use the data in the table, which shows the personal income and outlays (both in trillions of dollars) for Americans for 11 recent years. (Source: U.S. Commerce Department, Bureau of Economic Analysis) Personal income, x Personal outlays, y 5.6 4.6 5.8 4.9 6.2 5.2 6.5 5.5 6.9 5.8 7.4 6.1 7.8

Regression model

The following data gives the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade jobs soon after graduation. The starting salary, grade- point average (GPA), and major (business or other) are provided. Salary $29,500 $46,000 $39,800 $36,

Calculate the regression equation

Calculate the regression equation using Excel, including the R Square, Slope, Intercept and the formula Y = a +bX with % Welfare as the X variable and % Passing as the Y variable.

Statistics - Bivariate Regression.

In the following regression, x = weekly pay, y = income tax withheld and n = 35 McDonalds employees. a) write the fitted regression equation b) state the degrees of freedom for a two tailed test for zero slope and use Appendix D to find the critical value at alpha = .05 c) what is your conclusion about the slope? d) interp

Regression Analysis: Implementation and Interpretation

I. Simple Regression to Estimate Parameters. (A) Simple regression model with sales revenue as the dependent Y-variable and R&D expenditures independent X-variable. (B) Simple regression model with profits as the dependent Y-variable and R&D expenditures independent X-variable.

An expert witness in a case

An expert witness in a case of alleged racial discrimination in a state university school of nursing introduced a regression of the determinants of salary of each professor for each year during an 8-year period (n= 423) with the following results with dependent varable year (year in which the salary observed) and predictors year