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 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
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
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
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
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
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
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
Use NCSS to conduct all statistical tests and calculations. For each question, you are to edit, copy, paste and highlight the appropriate output from NCSS and produce a typed document answering the questions. Be succinct. Control the Type I error rate at the 0.05 level for all statistical test procedures and confidence interval
File with full description attached... Linear Regression Analysis The housing market is no stranger to trends and how those trends affect every aspect of that market. The trends are common factors that occur over a time period and that element is what regression and the trend method focus on. Trends are ever changing and thi
The following data show U.S. production of motor vehicles versus tons of domestic steel shipped for motor vehicle manufacture. Year X=U.S. Production of Motor Vehicles Y=Tons of Domestic Steel 2000 12.83 million 16.06 million 2001 11.52 14.06 2002 12.33 14.0 2003 12.15 15.88 2004 12.02 13.86 a. Determine the least-squar
For the y and x values listed in file XR15066, obtain the simple linear regression equation, then analyze the residuals by (a) constructing a histogram, (b) using a normal probability plot, (c) plotting the residuals versus the x values and (d) plotting the residuals versus the order in which they were observed. Do any of the as
The following data represent x = boat sales and y = boat trailer sales from 1995 through 2000.0 Year Boat sales (thousands) Boat trailer sales (thousands) 1995 649 207 1996 619 194 1997 596 181 1998 576 174 1999 585 168 2000 574 159 a. determine that least-squares regression line and interpret its slope b. estimate,
My brother would like to retire and move to a quieter place, probably away from me. I suggested area around Lake Louise. But he had a more remote location in mind...... He did some housing market research in a secret destination, and would like to have me taking a look at his data. Square Footage Asking Price (Canadian
In these two exercises, construct a scatter plot, find the value of the linear correlation coefficient r, find the critical value of r from Table A-6 by using α = 0.05, and determine whether there is a linear correlation between the two variables. Song Audiences and Sales The table below lists the numbers of audience
Please see attached. According to the Capital Asset Pricing Model (CAPM), the risk associated with a capital asset is proportional to the slope ß obtained by regressing the asset's past returns with the corresponding returns of the average portfolio called the market portfolio. (The return of the market portfolio represents
3. Given are five observations collected in a regression study on two variables. X1 | 2 6 9 13 20 Y1| 7 18 9 26 23 a. Develop a scatter diagram for these data. b. Develop the estimated regression equation for these data. c. Use the estimated regression
1. The least squares regression line given above is said to be a line which "best fits" the sample data. The term "best fits" is used because the line has an equation that minimizes the ______, which for these data is______. 2. For the data point (225.3, 308.1), the value of the residual is_____. (Round your answer to at le
After deciding on the appropriateness of a linear model relating coffee sales and maximum temperature, the managers calculate the equation of the least squares regression line to be Yhat = 2492.09 - 10.48X. 1) For these data, coffee sales values that are greater than the meand of the coffee sales values tend to be paired with
Recently, students in a marketing research class were interested in the driving behavior of students. Specifically, the marketing students were interested if exceeding the speed limit was related to gender. They collected the following responses from 100 randomly selected students:
The monthly number of permits granted for building houses in a large city is seasonal (there tend to be more permits granted for construction during spring and summer months than during winter months). The following table shows the monthly seasonal indexes for building permits: JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Complete a Bivariate Regression Problem including: scatter plot, correlation coefficient, t-test for coefficient.
Instructions for Exercises 12.4-12.6: (a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y? (b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. (c) Use Excel or Appendix D to find t.05 for a two-tailed test. (d) Calculate the t test statis
I need help in determining the co-efficient of determination for the above hypothesis using the correlation/regression analysis. The data sheet used is below: Literacy % Life Expectancy 1 52.0 62.7 2 57.1 51.1 3 58.0 67.0 4 61.6 70.0 5 62.8 68.1 6 72.1 70.0 7 76.2 75.7 8 78.6 76.3 9 79.0 72.6 10 79.2 74.3 11 81.1
Please see the attached file. The scatter-plot above shows the proportion of perch eaten by bass against the number of perch in a pen before the bass were let in. There is a roughly linear pattern. The least-squares line for predicting proportion eaten from initial count of perch is: Proportion eaten= 0.120 + (0.0086 x count
Multiple regression equation. Given the computer output from a regression analysis, write the regression equation, describe the variables, and decide of some of the variables should be eliminated from the equation.
Thompson Machine Works purchased several new, highly sophisticated machines. The production department needed some guidance with respect to qualifications needed by an operator. Four variables were listed. X1 = Length of time employee was a machinist X2 = Mechanical aptitude test score X3 = Prior on -the-job rating X4 = A
Regression Analysis Interpretations of population and sales data. Interpret the findings and discuss implications for business.
A bank has offices in six different markets. It is feasible to say the annual sales of offices are related to the population of the communities they are in. The dependent variable, y, is annual sales. The independent variable, x is market population. A regression analysis was conducted using Excel and the results of this
Regression Analysis We want to investigate the relationship of several factors to employees' current salaries. Included in the data is a sample of 37 employees. The first column is an ID. The second column is the time, in months, in their current job (VAR 1). The third column is the time, in years of related job experienc
Please see the attached file. 13.30 A researcher used stepwise regression to create regression models to predict birth rate (births per 1000) using five predictors, life exp (life expectancy in yeras), inform (infant mortality rate), density (population density per square kilometer), GDP cap (Gross domestic product per capita),
An advertising firm wishes to demonstrate to potential clients the effectiveness of the advertising campaigns it has conducted. The firm is presenting data from recent campaigns, with the data indicating an increase in sales for an increase in the amount of money spent on advertising. In particular, the least-squares regression
What is the least squares regression line equation ? What are the slope and the y-intercept? What is the R-squared value? Conclusion make specific comments and give reasons regarding any similarities or differences in the output results. Which regression produces the strongest correlation coefficient result? Why?