Explore BrainMass
Share

# Regression Analysis

### Time series Data Analysis: scatter plot and trend analysis

14.16 (a) Plot the data on U.S. general aviation shipments. (b) Describe the pattern and discuss possible causes. (c) Would a fitted trend be helpful? Explain. (d) Make a similar graph for 1992-2003 only. Would a fitted trend be helpful in making a prediction for 2004? (e) Fit a trend model of your choice to the 1992-2003 data.

### Understanding a regression hypothesis test

1. In 250-300 words interpret the result of the regression hypothesis test. H0: What is the trend of salaries for educational levels among females and males? X Female Male Less 1 \$20,420.16 \$29,271.71 HS 2 \$22,647.65 \$32,464.75 Degree 3 \$35,652.27 \$51,106.52 (We denoted the educational levels on a scale of 1-3)

### Bivariate regression model and caveats

1 (a) What is a bivariate regression model? Must it be linear? (b) State three caveats about regression. (c) What does the random error component in a regression model represent? (d) What is the difference between a regression residual and the true random error? 2. (a) Explain how you fit a regression to an Excel scatter plot.

### Regression Analysis of Professor Salaries

See the attached file. Question 1 - 5 1992-1993 Salary data for a sample of 15 universities was obtained. We are curious about the relationship between mean salaries for assistant professors (junior faculty) and full professors (senior faculty) at a given university. IN particular, do universities pay (relatively) high sala

### Correlation and Regression

This week we are working on correlation and regression. All work that can be done in SPSS must be submitted in that format. 1. Dr. Allen suspects a strong correlation between math anxiety and performance in statistics. To test that hypothesis he collects the following data. Math Anxiety 1st Exam Score 78 42 68

### Create a scatterplot of the data and interpret the regression equation

For a sample of 100 employees, a personnel director has collected data on x = the number of years an employee has been with the firma dn y = the number of shares of company stock the employee owns. With the following information: a. Generate a scatter diagram that includes the best fit linear equation for these data. b. Doe

### Trend Lines through Time Series Data

THE FOLLOWING TIME SERIES DATA REPRESENTS THE MEAN YEARLY US UNEMPLOYMENT RATE BETWEEN JANUARY 1981 AND OCTOBER 2008 (OBTAINED FROM THE U.S. BUREAU OF LABOR STATISTICS): Year U.S. Unemployment Rate (%) 1981 7.62 1982 9.71 1983 9.60 1984 7.51 1985 7.19 1986 7.00 1987 6.18 1988 5.49 1989 5.26 1990 5.62 1991 6.85 1992

2-3 PAGES WITH EXCEL GRAPHS. SEE ATTACHED FILE. Use the Cartesian coordinate system to find the distance between two points; illustrate linear functions and their relationship to business, economics, social science, etc., and find the intersection of two lines. Great news! ABC Advertising has called you in for an interview

### Time Series Forecasting using exponential smoothing.

Need help with the attached problem. Please provide solution and explanation in EXCEL format. ============================================================= Problem #7.6 Following are time-series data for nine time periods. Use exponential smoothing with constraints of .3 and .7 to forecast time periods 3 through 9. Let t

### Statistics - Interpreting Regression Output

A researcher used stepwise regression to create regression models to predict BirthRate (births per 1,000) using five predictors: LifeExp (life expectancy in years), InfMort (infant mortality rate), Density (population density per square kilometer), GDPCap (Gross Domestic Product per capita), and Literate (literacy percent). Inte

### Statistics: Understanding Regression Analyses

Question 1: In the following regression, X = weekly pay, Y = income tax withheld, and n = 35 McDonald's 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 £ = .05. (c) What is your conclusion about the

### Understanding regression output and hypothesis testing.

In Hawaii, condemnation proceedings are underway to enable private citizens to own the property that their homes are built on. Until recently, homeowners leased the land from the estate. In order to comply with the new law, a large Hawaiian estate wants to use regression analysis to estimate the fair market value of the land. Ea

### Regression with forecast: Plot data, fit a trend line, and make a forecast (Excel).

14.16 (a) Plot the data on U.S. general aviation shipments. (b) Describe the pattern and discuss possible causes. (c) Would a fitted trend be helpful? Explain. (d) Make a similar graph for 1992-2003 only. Would a fitted trend be helpful in making a prediction for 2004? (e) Fit a trend model of your choice to the 1992-2003 data.

### Regression analysis and 5-Step Hypothesis Test

1. Perform a regression analysis and show the scatter plot of data with the regression line superimposed. 2. Discuss the import of the following statistics: a. Correlation coefficient b. Coefficient of determination c. Slope and intercept of the regression equation 3. Create a 5-Step Hypothesis test.

### Basic Business Statistics regression and correlation

1. In a simple linear regression problem, r and b1: a. may have opposite signs. b. must have the same sign. c. must hae opposite signs. d. are equal 2. A professor of industrial relations believes that an individual's wage rae at a factory (Y) depends on his performance rating (X1) and the number of economics courses th

### Understanding Regression Analysis: sums of squares

The variation attributable to factors other than the relationship between the independent variables and the explained variable in a regression analysis is represented by: a. regression sum of squares. b. error sum of squares. c. total sum of squares. d. regression mean squares.

### Understanding variability and R^2 in regression results.

The following Excel tables are obtained when "Score received on an exam (measured in percentage points)" (Y) is regressed on "percentage attendance" (X) for 22 students in a Statistics for Business and Economics course. -------------------------------- Regression Statistics -------------------------------- Multiple R

### Statistics - Bi-variate Regression Analysis in Excel

I have a two question problem with three sub questions that I need help with for my Statistics class. It is supposed to deal with Bi-variate analysis. If someone can help me out with this, it would be much appreciated. 1. Perform a regression analysis Show the scatter plot of data with the regression line superimposed.

### Understanding correlation: scatter plots, coefficient of correlation, coefficient of determination, and a regression equation.

1st problem A study is conducted concerning automobile speeds and fuel consumption rates. The following data is collected: Speed MPG 44 22 51 26 48 21 60 28 66 33 61 32 a. Plot these data in a scatter diagram. b. Compute the coefficient of correlation. 2nd problem Tem Rousos, preside

Consider the enrollment data for Business Week's top 50 U.S. graduate business programs in the file P2_3.XLS which is set out below. PROBLEM: Using excel and excel statistical functions, solve the following: (a) Use the data in the file P2_3.XLS - set out below - to estimate a multiple regression model to assess whether

### Multiple regression models using excel for Beta Technologies Inc

Multiple regression models using excel Managers at Beta Technologies, Inc., have collected current annual salary figures and potentially related data for a random sample of 52 of the company's full-time employees. The data are in the file P2_1.XLS set out below. These data include each selected employee's gender, age, numb

### Multiple regression model - standard error of the estimate

INSTRUCTIONS: Add new part (b): give the value of and interpret the standard error of the estimate. Add new part (c): give the predicted number of contracts sold for a month with an average contract price of \$3,000, adv exp of \$20,000, and per sell exp of \$40,000. New part (d): give a 95% PI for the prediction of part c, ba

### Regression of yearly truck maintenance expenses

I need help setting up and solving the following problem which is set out with the data needed in that attached excel spread sheet. INSTRUCTIONS: Note: "Interpret" in a problem means you should explain in words what something (in this case each regression coefficient (separately)) means. (add new part c: predict the maintena

### Multiple Choice Questions on simple, linear, bivariate regression, multiple regression, time series

Please see attached file First some questions about simple, linear, bivariate regression. 1 Of these correlation coefficient values, which represents the least strength of correlation? A +0.4 B +0.1 C -0.2 D -0.5 2 The t test for significance of the correlation coefficient has how many degrees of freedom? A

### Statistical problem: Predict the number of employed people using linear regressing analysis.

My hypothesis for a paper I am writing is: There will be more people working past the age of 65 in 2012 than there were in 1997. I have done some more research and need help plotting this out on a Linear Regression. I believe this can be done by plotting out every 3 years average number of people working past 65 since 19

### Simple analysis - You may add any second variable

You may add any second variable.Please find attached a simple regression analysis, and make it a multiple regression analysis example(i.e., with two independent variables). I have attached the one variable analysis (simple) for reference. You may add any variable with any dummy data. (a) Please address your final choice betw

### Conduct a Regression Analysis Given a Data Set.

The hypothesis test will evaluate the Century National Bank data set to determine if a relationship exists between the two variables. The hypothesis test of r2 will attempt to predict if r2 is larger than zero. The variables to be tested from the data set is whether or not there is a relationship between the number of bank serv

### Multiple regression model problems

A multiple regression model has the form: Yhat = 5.25 + 2.5*X1 + 4*X2 As x2 increases by 1 unit, holding constant x1, then the value of y will increase by: a. 2.5 units b. 7.75 units c. 4 units on average d. 11.75 units on average

### Regression Analysis with Excel

Using Excel as your processing tool, work through three simple regression analyses. 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 data set as the dependent variable. Create a graph wi

### Making predictions based upon regression equation

For the multiple regression equation y-hat = 100 + 20x1 - 3x2 + 120x3 a. identify the y-intercept partial regression coefficients b. if x1 = 12, x2 = 5, and x3 = 10, what is the estimated value of y? c. if x3 were to increase by 4, what change would be necessary in x2 in order for the estimated value of y to remain unchange