Explore BrainMass

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

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

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


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?