Explore BrainMass

Regression Analysis

Seafood restaurant

The manager of a seafood restaurant was asked to establish a pricing policy on lobster dinners. Experimenting with prices produced the following data: Average Number Sold per Day, y Price, x 200 $6.00 190

Correlation and regression: key informaiton

Use the data in the table, which shows the personal income and outlays (both in trillions of dollars) for Americans for 11 recent years. (Source: U.S. Commerce Department, Bureau of Economic Analysis) Personal income, x Personal outlays, y 5.6 4.6 5.8 4.9 6.2 5.2 6.5 5.5 6.9 5.8 7.4 6.1 7.8

Regression model

The following data gives the starting salary for students who recently graduated from a local university and accepted jobs soon after graduation. The starting salary, grade jobs soon after graduation. The starting salary, grade- point average (GPA), and major (business or other) are provided. Salary $29,500 $46,000 $39,800 $36,

Calculate the regression equation

Calculate the regression equation using Excel, including the R Square, Slope, Intercept and the formula Y = a +bX with % Welfare as the X variable and % Passing as the Y variable.

Regression Analysis: Implementation and Interpretation

I. Simple Regression to Estimate Parameters. (A) Simple regression model with sales revenue as the dependent Y-variable and R&D expenditures independent X-variable. (B) Simple regression model with profits as the dependent Y-variable and R&D expenditures independent X-variable.

Simple Regression Analyses

Prepare a report using Excel as your processing tool to process three simple regression analyses. 1. 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.

Correlation and regression analysis

Residual Plot: Consider the data in the table below. A. Examine the data and identify the relationship between x & y. B. Find the linear correlation coefficient & use it to determine whether there appears to be a significant linear correlation between x & y. C. Construct a scatter plot. What does it suggest about the relatio

Regression equation for predictions

Find the equation of the regression line for the given data. Use the regression equation to predict the value of y for each of the given x-values, if meaningful. The caloric content and the sodium content (in milligrams) for 6 beef hot dogs are shown below. Calories, X 160 170 130 130 90 180 Sodium, Y 415

Regression analysis

Imagine you are a real estate investor presented with a regression analysis of home sales near one of your investment properties. Use Stat tools regression mod3l to determine: Which is a better predictor of selling price:appraised value, square footage, or number of bedrooms? A) How much value is added per $1000 OF APPR

Significance in Statistics

Problem: Do Hispanics earn more than white individuals at a large company, for which lawsuit filed. Attached data include, 1. Employee ID, 2. Job title, 3. Ethnicity, 4. Yrs. Working. 1. Is pay different by ethnicity and if so are they statistically significant, and what is meaning of such. Consider some of the arguments t

Unit 5 Statistics Help...please

Hi, I need help with this assignment. I am using a different Dataset then what is in the solution library. My data set is 0903A.Xls.My school uses Turn it which is a similarity score and if it matches too high The assignment mentions a DATA SET 903A which i have provided - I have attached this information. Thank you and ple

Regression analysis problems - Bus Inc. sells widgets

Bus Inc. sells widgets. Sales dept says there is a positive linear relationship between the advertising expenditures and sales. Sales department recently analyzed the sales over 42 weeks. For each week in the sample, Bus Inc sales (SALES) and their advertising expenditures (ADVERT) were recorded. A simple regression analysis was

Statistic help

An agent for a residential real estate company in a large city would like to be able to predict the monthly rental cost of apartments based on the size of the apartment.At the .05 level of significance determine if the correlation between rental cost and apartment size is significant? Rent Size 950 850 1600 1450 1200 1085 1

Multiple Regression Analysis

The task is to provide evidence, for or against, common perceptions about property crime. Are crime rates higher in urban than rural areas? Does unemployment or education level contribute to property crime rates? How about public assistance? What other factors relate to property crimes? The file named Data File may help answer s

General Statistics questions

1. What is the variable used to predict the value of another called? A) Independent B) Dependent C) Correlation D) Determination 2. Based on the regression equation, we can A) predict the value of the dependent variable given a value of the independent variable. B) predict the value of the independent

Multiple Regression

Please see the attached 2 problems. Please provide a step by step solution and also use Excel to arrive at the answers. Thank you. Problem 1: The US Government has asked for your assistance in determining the acceptability of structural bolts provided by a supplier. The bolts must be 1.84 centimeters in diameter. You select

What does the formula, Yeild =a +b1*precip+b2*acres mean? what do they stand for?

To understand a regression equation we need to understand what the variables are and what the parameters are. The variables in this case are "Nut Yield" in California, "precipitation" based on annual rainfall data, and "acres" which refers to the number of acres planted. Next are the parameters. "a" is the intercept. It te

Statistics - Correlation & Regression

The owner of Maumee Ford-Mercury wants to study the relationship between the age of a car and its selling price. Listed below is a random sample of 12 used cars sold at Maumee Motors during the last year. Age (Years) SELLING PRICE ($000) 9 8.10 7

Multiple regression problem and analysis

4. Market Planning, Inc. a marketing research firm, has obtained prescription sales data for 20 independent pharmacies (see below). In this table, the following variables are included: Sales over the past year (in units of $1,000), Floor space (square feet), Percentage of floor space dedicated to the pharmacy (square feet), Numb

Correlation and Regression applied to a dataset of alcohol-related crash history

Please take the data I provide and do the computations and graphing for me, then explain the results to me so that I can write a paper and give a presentation on it. Here is my assignment: Prepare a 1,000 - 1,500 word paper applying Regression and Correlation to a personal or business application the student is familiar

Quantitative analysis

4-20 The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the last 6 months. Develop three regression models to predict the selling price based upon each of the other factors individually. Which of these is best?

Building multiple regression model

I need help answering these questions. Enclosed in the multiple regression model that the questions refer too and also the Table A & B that are referred to in question 2 & 3. This case involves the decision to locate a new store at one of two candidate sites. The decision will be based on estimates of sales potential. Pro

Regression effect

A human resources director, on learning about the regression effect, decides to hire people who have been fired by their previous employer for poor performance. He argues that the regression effect says people who perform very poorly in their previous job tend to perform well in their next job. Is this what the regression ef

Regression model

Interpret the following: (a) Y = a + BX; Y = 3.5 + .7X, where Y = likelihood of buying a new car and X = total family income. (b) Y = a + BX; Y = 3.5 - .4X, where Y = likelihood of buying tickets to a rock concert and X = age.