Explore BrainMass

Explore BrainMass

    Regression Analysis

    BrainMass Solutions Available for Instant Download

    Model to Predict the Assessed Value of Houses

    Please see the attached file. You want to develop a model to predict the assessed value of houses, based on heating area. A sample of 15 single-family houses is selected in a city. The assessed value (in thousand of dollars) and the heating area of the houses (in thousands of square feet) are recorded, with the following res

    Various Regression Questions

    Please help with the attached questions. 12. 48 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.

    Multiple regression analysis and hypothesis testing problems

    1. Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indi-cates the number of client contacts last month, and th

    Multiple Regression for DJIA

    Consider the following regression model: ? D = percent change in DJIA (Dow Jones Ind. Avg.); ? O = per barrel price of oil; ? I = interest rates (in real number percentages: 6%, etc); ? E = corporate earnings growth rate; ? G = GDP growth rate. ? R2 = 0.8500 ? F = 24 ? F(Se) = 1.0 ? D = 2.0 - 3.0I + 1.5E - 1

    You are the general marketing manager of Ford Motor company.

    You are the general marketing manager of Ford Motor company. The CEO of the company asked you to assess the viability of producing alternative fuel automobiles (ex, ethanol). What types of forecasting techniques would you use to forecast sales? Should you determine that regression analysis may be beneficial in addressing this qu

    Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution.

    3. Bi-lo Appliance Stores has outlets in several large metropolitan areas. The general sales manager plans to air a commercial for a digital camera on selected local TV stations prior to a sale starting on Saturday and ending Sunday. She plans to get the information for Saturday-Sunday digital camera sales at the various outlets

    Linear Regression Analysis and Hypothesis Testing

    I need your assistance with a linear regression analysis and a regression hypothesis test on my data. My hypotheis statement is: "Is there a difference in earnings between women with a two-year or four-year college degree?" Ho, they are the same and Ha, is equal to or greater than Ho. This is my data, 2 year degree earnings are

    Correlation Coefficient and Regression Equations

    An area of concern for the committee is that pay rates are linked in large measure to seniority. The committee realizes the relationship can't be perfect, other factors such as merit and contribution to the company are also used to determine pay. The committee thinks if there is a strong relationship that could be used to induce

    Tree diagram: A. Perform a decision tree analysis of Steeley Associates' decision situation using expected value, and indicate the appropriate decision with these criteria. B. Indicate the decision you would make, and explain your reasons.

    Case Problem #2 Steeley Associates, Inc. a property development firm, property development firm purchased an old house near the town square in Concord Falls, where State University is located. The old house was built in the mid-1800s, and Steeley Associates restored it. For almost a decade, Steeley has leased it to the univer

    Correlation, Regression Analysis, Coefficient of Correlation

    (a) How does correlation analysis differ from regression analysis? (b) What does a correlation coefficient reveal? (c) State the quick rule for a significant correlation and explain its limitations. (d) What sums are needed to calculate a correlation coefficient? (e) What are the two ways of testing a correlation coefficient

    Time-Series Analysis in Excel

    Make an Excel graph of the data on U.S. online advertising spending. (b) Discuss the underlying causes that might explain the trend or pattern. (c) Use Excel, MegaStat, or MINITAB to fit three trends (linear, quadratic, exponential) to the time-series. (d) Which trend model do you think is best to make forecasts for the next 3 y

    Bivariate Regression in Excel

    (a) Make an Excel scatter plot. What does it suggest about the population correlation between X and Y? (b) Make an Excel worksheet to calculate SSxx , SSyy , and SSxy. Use these sums to calculate the sample correlation coefficient. Check your work by using Excel's function =CORREL(array1,array2). Find t.05 for a two-tailed tes

    Scatterplot and regression

    Please see attachment! Use the data from Exercise #12.3 below. (a) Plot a scatter diagram, (b) Show the equation on the plot using the trendline option of Excel, (c) State the value of the slope, and (d) State the value of the intercept. Use the data from Exercise #14.1 (see below) and (a) Plot a scatter dia

    Forecasting - Linear Regression

    I'm working on linear regression and I'm stuck on the equation because I'm coming up with a negative number which I don't think is an accurate forecast. The problem also asks for error tests, which I think I have the correct formulas for and will work once the first part is done. Please help! Full details and questions attached

    Regression analysis between work fatalities and unemployment

    A highway employee performed a regression analysis of the relationship between the number of construction work-zone fatalities and the number of unemployed people in a state. The regression equation is Fatalities _ 12.7 _ 0.000114 (Unemp). Some additional output is: Predictor Coef SE Coef T P Constant 12.726 8.115 1.57 0.134

    Statistics Questions

    Please see the attached file. 15.2 Teenagers make up a large percentage of the market for clothing. Below are data on running shoe ownership in four world regions (excluding China). Research question: At α = .01, does this sample show that teenage running shoe ownership depends on world region? (See J. Paul Peter and Jer

    Time series analysis

    Barbara lynch is the product manager for a line of skiwear produced by Health Co Industries and privately branded for sale under several different names .A part of Ms Lynch's is to provide a Quarterly forecast of sale for the northern United State ,a region composed of 27 states stretching from Maine to Washington. A 10 years hi

    Multiple regression analysis problems

    3. The director of marketing at Reeves Wholesale Products is studying the monthly sales. Three independent variables were selected as estimators of sales: regional population, per-capita income and regional unemployment rate. The regression equation was computed to be (in pounds). Y' = 64,100 + 0.394X1 + 9.6X2 + 11,600X3

    Bingo Hamburger Co has a chain of 12 stores in a large city.

    Bingo Hamburger Co has a chain of 12 stores in a large city. Sales figures and profits for the stores are given in the following table. Obtain a regression line for the data & predict profit for a store assuming sales of $10 million. X Y SALES PROFITS $7 $.15 2 .10

    Regression Analysis: Example Problem and Solution

    I am trying test what is the positive or negative correlation between the price of a gallon of retail gasoline and the company profits. The company profits range from 0 to 25 billions dollars, while the gas prices range from $2.71 to $3.79 dollars per gallons. Use the regression equation: Y'= a + bX

    Forecasting using different methods

    A manufacturer has experienced the following monthly demand for one of their products Month Actual Demand (in cases) Feb 1500 March 2860 April 2950 May 3490 June 3000 July 3200 Aug

    simple linear regression models

    Develop simple linear regression models for predicting Games Won as a function of each of the independent variables in the 2000 NFL Data.xls worksheet individually. Do the assumptions of linear regression hold for your models? How do these models compare to the multiple regression models?

    When to use Correlation or Regression Analysis

    1. Please describe a situation in which a correlation analysis or regression analysis could contribute to a better decision. The situation can be from a work, of general interest, or experienced in private life. 2. Please describe a situation in which correlation analysis or regression analysis can be (or was) misused to

    Statistics - Regression Output - Interpretation

    In the following regression, X = total assets ($ billions), Y = total revenue ($ billions), and n = 64 large banks. (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

    Scatter Plot for Absences Versus Grades

    10. You are given the following data. Number of Absences Final Grade 0 96 1 91 2 78 2 83 3 75 3 62 4 70 5 68 6 56 a. Make a scatter plot for the data. b. Find the correlation coefficient for the data. c. Find the equation for the regression line for the data, and predict the final grade of a student who misses 3