Explore BrainMass
Share

# Regression Analysis

### Using Excel: Correlation Work

Please see the attached Excel worksheet for my questions on correlation. I need to answer the following questions: A) Use the Excel Analysis ToolPak to find the linear correlation coefficient for the systolic and diastolic measurements. B) Use the Excel Analysis ToolPak to determine the linear regression equation that us

### Hypothesis Testing, Statistical Inference, and Regression Analysis

1, Explain the difference between the null and alternative hypothesis. Which one can be proven in a statistical sense? 2. What are the differences between one- and two- sample hypothesis tests? Describe the correct mathematical form for specifying the null and alternative hypotheses for both types of tests. 3. Explain Type I

### Multiple Regression Results For Fast-Growth Firms

For the 50 states, consider a multiple regression analysis to explain the number of new jobs created, using the number of new firms created and the percentage of fast-growth companies. The variables used are "new jobs" (in thousands), "new firms" (actual number of firms), and pct fast" (in percentage points, so that, for exampl

### Find the equation of the regression line for the given data.

Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (The pair of variables have a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The table below shows the heigh

### Multiple regression predicting GPA

To get an even better model for predicting MBA performance, let's look at many variables. Create a multiple regression model predicting the MBA GPA using the BS GPA, the Hours studied per week, the Gender of the student, whether the student works full-time, and the student's age. Use a .05 significance level. After you create yo

### Finding the Regression Equation

12 Use technology to find the regression equation for the data shown in the table. Then answer the following. a) What is the standard error estimate? b) What is the coefficient of determination? What is the regression equation? Y = _______ + (_______)x₁ + (_______)x₂ (round three decimal places as needed) a) The s

### Regression Equation: Slope Coefficient Determination

A sample of 12 homes sold last week in St Paul, Minnesota, is selected. The results are shown below Home Size (1000 square feet) Home Price (\$1000) 1.4 100 1.3 110 1.2 105 1.1 120 1.4 80 1 105 1.3 110 0.8 85 1.2 105 0.9 75 1.1 70 1.1 95 Create a scatterplot. Insert the trendline into the graph and show the reg

### Scatter Plot Linear Regression

Can you help me create a scatterplot, with an inserted trend line, showing the regression equation using the data below? A sample of 12 homes sold last week in St Paul, Minnesota, is selected. The results are shown below. Home Size (1000s sq feet) Home Price (\$1000) 1.4 100 1.3 110 1.2 105 1.1 120 1.4 80 1 105 1.3

### Linear Correlation, Regression Lines and Measures of Variation

1) Testing for a Linear Correlation Construct a scatter plot, find the value of the linear correlation coefficient r, and find the critical values of r from the table below using a=0.05. Determine whether the is sufficient evidence to support a claim of a linear correlation between the two variables. Airline Fares Listed be

### Regression Analysis with Excel

I need help constructing a regression analysis. Using the attached spreadsheet and Word Doc help develop the following 3 regressions. Please show what is used as the Y and X ranges and explain the steps. A. Estimate a one factor, or CAPM, regression analysis of the following form: Ri - Rf = ?j + ?i(RM - Rf) B. Estimate

### A Multiple Regression Model

In a multiple regression model y' = -10 + 2x1 + 19x2 + 14x3 + 2x4, if the x1 value changes by 2, then the predicted value for y will change by (the 1,2,3,4 are all little numbers sit lower than then x-could not figure out how to type that correctly).

### Is a student's ACT score is a good predictor of their final college grade point average?

You are interested in finding out if a student's ACT score is a good predictor of their final college grade point average (GPA). You have obtained the following data and are going to conduct a regression analysis. ACT GPA 22.0 3.0 32.0 3.78 33.0 3.68 21.0 2.94 27.0 3.38 25.0 3.21 30.0 3.65 a) What is the R? What ty

### Responding to a Correlation Analysis

Bill is doing a project for you in the marketing department. In conducting his analysis regarding consumer behavior and a new product that has come out, he tells you the correlation between these two variables is 1.09. What is your response to this analysis?

### Equation of Regression

The gas tax and fuel use are shown. tax: 21.5, 23, 18, 24.5, 26.4, 19 Usage 1062, 631, 920, 686, 736, 684 How would I find y' when x = \$0.25 "For this problem find the equation of the regression line and find the y1 value for the specified x value. Remember that no regression should be done w

### Regression Analysis

The marketing manager of a large supermarket chain would like to use shelf space to predict the sales of pet food. A random sample of 12 equal-sized stores is selected, with the following results (see attachment called PetFood). A. Construct a scatter plot. For these data b0 = 145 and b1 = 7.4 B. Interpret the meaning of th

### Regression Analysis Y/X Intercept

See the attached file. The regression analysis below relates U.S. annual energy consumption in trillions of BTUs to the independent variable "U.S. Gross Domestic Product (GDP) in trillions of dollars." Which of the following statements is true? Energy Consumption and GDP Source * The y-intercept of the regr

### Conduct a Regresssion Analysis

The regression analysis below relates US annual energy consumption in trillions of BTUs to the independent variable "US Gross Domestic Product (GDP) in trillions of dollars." Which of the following is the lowest level at which the independent variable is significant? Energy Consumption and GDP Source 0.94 0.10 0.05

### Estimate the Industry Demand Curve for Product X

Assume your research staff used regression analysis to estimate the industry demand curve for Product X. Qx = 10,000 - 100 Px + 0.5 Y - 1000 r (3,000) (20) (0.3) (105) Where Qx is the quantity demanded of Product X, Px is the price of X, Y is income, and r is the prime interest rate (given in decimals, e.g., 0.02 or 0

### Perform Prediction Using the Multiple Regression Model.

A medical researcher found a significant relationship among a person's age x1, cholesterol level x2, sodium level of the blood x3, and systolic blood pressure y. The regression eqauation is y1 = 97.7 + 0.691x1 + 219x2 - 299x3. Predict the systolic blood pressure of a person who is 35 years old and has a cholesterol level of 194

### Statistics: Regression Line

The following readings were taken in a laboratory experiment: x | 0 | 5 | 10 | 15 | ----------------------------------------- y | 3000 | 3501 | 4022 | 4525 | Determine the equation of the form y = mx + b that fits the data in a least squares sense. (1) y = 101.92x + 2997.6 (2) y = x + 3000

### find the best prediction model

Resource: Ch. 12-14 of Applied Statistics in Business and Economics Prepare answers to the following assignments: Exercise 14.6 - Time Series Analysis Given the following data on Asian and European Share of U.S. Light Truck Sales(1990-2003): Year t Percent 1990 1 16.4 1991 2 17.1 1992 3 14.3 1993 4 13.7 1994 5 14.2 19

### Develop a regression model to predict selling price based on the square footage and number of bedrooms

SELLING SQUARE AGE PRICE(\$) FOOTAGE BEDROOMS (YEARS) 64,000 1,670 2 30 59,000 1,339 2 25 61,500 1,712 3 30 79,000 1,840 3 40 87,500 2,300 3 18 92,500 2,234 3 30 95,000 2,311 3 19 113,000 2,377 3 7 115,000 2,736 4 10 138,000 2,500 3 1 142,500 2,500 4

### Applied Statistics in Business and Economics

Correlation & Regression Analysis Do heavier cars use more gasoline? If so, can we predict the mileage rating of a car given its weight? Suppose 8 cars were randomly chosen and their weights (in hundreds of pounds) and mileage rating (mpg) are recorded. Weight (x) MPG (y) 27 30 44 19 32 24 47 13 23 29 40 17 34 21 5

### Regression Models

Provide some practical examples from work experience where regression models might be used.

### Correlation and Simple Linear Regression

1. Find the equation of the regression line for the given data. Predict the value of Y when X=-2? Predict the value of Y when X = 4? 2. The data below are the final exam scores of 10 randomly selected statistics students and the number of hours they studied for the exam. Find the equation of the regression line for the given

### Conducting a Linear Regression using R

1. The data for this problem give the infant mortality rate (per 1000 live births) in the United States for the period 1960-1979. (a) Generate a scatterplot for the data in R. Does the plot make sense? (b) Find the estimated regression equation using R, and give the units and real-world interpretations of the regression co

### Solving Linear Regression Problems: Example

Estimate a linear demand function for the Sunshine Valley brand by calculating the simple regression of units sold (SVE) on weekly average price (SVAVPR). Include the following: a. Your regression output. Note: it is unnecessary to include a listing of the data and a listing of the residuals. On the output mark the total var

### Qualitative variable

Consider the following time series data representing quarterly sales of dishwashers at Big Boys Appliances over the past two years: Time Sales 2010 Quarter 1 20 2010 Quarter 2 85 2010 Quarter 3 64 2010 Quarter 4 30 2011 Quarter 1 70 2011 Quarter 2 125 2011 Quarter 3 105 2011 Quarter 4 90 The scatter plot of the da

### Regression

Suppose you are given data from a survey showing the IQ of each person interviewed and the IQ of his or her mother. That is all the information you have. Your boss has asked you to put together a report showing the relationship between these two variables. What could you present and why?

### Multiple Linear Regression [Must be done in R]

Plots should be done in R, and data set is loaded through R. Please see attachment.