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

### Statistics Regression Model: find a point prediction for state, police, population, prisoners

See attached file. The given describes data for each state of the 50 states. -Total expenditures on a state's criminal justice system (in thousand of dollars)(EXPEND) -Total number of police employed in the state (POLICE) -Population of the state (in thousand) (POP) total number of incarcerated prisoners in the state (PRI

### Correlation for Service Call data for copiers in minutes

Problem Data Service Time Data x y Calls Copiers Minutes 1 4 109 2 2 58 3 5 138 4 7 189 5 1 37 6 3 82 7 4 103 8 5 134 9 2 68 10 4 112 11 6 154 I need: Estimate unknown model parameters The Least Squares Point Estimates

### 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 .

### Statistics: Correlation between a team's salary and the number of wins by the team?

See the attached file. o Formulate both a numerical and verbal hypothesis statement regarding your research issue. o Perform the five-step hypothesis test on data pertaining to your selection. o Describe the results of your test, and explain how the findings from this hypothesis testing can be used to answer y

### 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

### Linear Regression Analysis: Develop a wage question, formulate a hypothesis and test

See attached data file. Using numerical data from the data set attached, develop one research question and formulate a hypothesis which can be tested with linear regression analysis. Complete and describe the results of the linear regression analysis on the collected data. Be sure to include the following: i. Use the hy

### 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 Questions: regression, predictor variables, plot data, exponential trend

12.48 In the following regression, X = weekly pay, Y = income tax withheld, and n = 35. R(squared) 0.202 Standard Error 6.816 n 35 ANOVA Table Source SS df MS f P-value Regression 387.6959 1 387.6959 8.35 .0068 Residual 1,533.0664 33

### 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

### Statistics: Null hypothesis, critical value, ANOVA test, regression equation, chi-square

Please answer the 11 questions posted. 1. A production manager is conducting a Z test of her assembly line. She collects a sample of 64 items from the assembly line and determines that the test's critical value is +1.96 and the Z statistic is +1.73. Based on this information she should (circle one): Accept Reject the Nu

### Statistics: Does correlation equal causation; independent and dependent variable, OLS

DQ1: a) Does correlation equal causation? Does the strength of correlation depend on the direction? What is the meaning of a zero correlation? Explain your answers. DQ2: a) What is the difference between an independent and a dependent variable? What is a bivariate or simple regression model? Does a regression model

### 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

### Regression Analysis

Perform a regression analysis on the data using Microsoft Excel.

### 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