Explore BrainMass

Regression Analysis

Regression Analysis

A consumer organization wants to develop a regression model to predict mileage (as measured by miles per gallon) based on the horsepower of the car's engine and the weight of the car (in pounds). Date were collected from a sample of 50 recent car models, and the results are organized and stored in Auto. a. State the multiple

Regression and Correlation Analysis

For the following data on 10 persons, construct a scatterplot showing the relationship between age and number of children, and describe the relationship in verbal terms. Person (i) Age(X) Number of Children (Y) 1

Simple Linear Regression Analysis - Correlation Coefficient

Q: A very broad consensus has emerged around the proposition that global warming is a reality with likely serious global consequences. Moreover, while there is still not unanimity that is desirable to cut emissions from coal and petroleum. Finally, many energy economist and political leaders are advocating a multipronged approac

Regression analysis for data on lettery, education, age, children

See attached data file. 3. Attached you will find the excel data and analysis on the topic of 'playing the lottery'. It is often claimed that individuals who play the lottery are those who can least afford to do so, making the impact of the lottery 'regressive'. In this context, regressive implies that lower income indivi

Chi-square Test, Regression Analysis and Correlation

See file attached for proper format of tables. 12.5 A sample of 500 shoppers was selected in a large metropolitan area to determine various information concerning consumer behavior. Among the questions asked was, "Do you enjoy shopping for clothing?" The results are summarized in the following contingency table: Enjoy Shop

Completing a Regression Analysis

See the attached file for proper formatting. Please solve the exercise below in Excel and show your work, along with the formulas. Scenario: A local tire dealer wants to predict the number of tires sold each month. He believes that the number of tires sold is a linear function of the amount of money invested in advertising.


8. U.S. News & World Report publishes the average starting salary and the average GMAT score for MBA graduates at each of the top 80 ranked schools in the country. The data fit the following regression line: Y = 288X - 111,408 where X is the average GMAT score for students at a school and Y is the average starting salary for gr

Statistics, equation of regression line, interpretation of regression line

7. Store records show that people who live closer to a store tend to purchase more. The relationship between the distance to the store in miles (X) and the amount a customer spends over the year in dollars (Y) fits the following regression line: Y = -100 X + 1000. If a customer lives 7 miles from the store, what is the predicte

Regression analysis: Assessed value of small medical office buildings

Using Data set C, complete the template provided in the Excel file attached. Regression analysis: Assessed value of small medical office buildings obs assessed floor offices entrances age freeway 1 1796 4790 4 2 8 0 2 1544 4720 3 2 12 0 3 2094 5940 4 2 2 0 4 1968 5720 4 2 34 1 5 1567 3660 3 2 38 1 6 1878 5000 4 2 31

Multiple regression analysis: Size of bill vs number of days the bill is late

See attached file for data. Need assistance in producing the charts, graphs and analysis associated with this project. This exercise involve multiple regression analysis. We want to determine whether the size of the bill has an effect on the number of days the bill is late. The statistical analysis of the data involves

MA 14-34. Cost Estimation, Interpretation, and Analysis

Carolina Table Company produces two styles of tables, dining room and kitchen. Presented is monthly information on production volume and manufacturing costs: Please see Ms Excel attachment Required: a. Use the high-low method to develop a cost-estimating equation for total manufacturing costs. Interpret the meaning of t

Regression analysis is performed.

In table 4.1 of your text, an equation was estimated after applying regression analysis techniques on the data of A, B, C, D sets of Y = 3 + 0.5X. What does 3 and .5 mean? Is this slope positive or negative? Is the slope positive or negative of the equation Y = 5 â?" 0.3X? How can you quickly tell whether or not it is a po

Multiple regression models to predict birth rates

Please see attached file for proper format. 13.30 A researcher used stepwise regression to create regression models to predict BirthRate (births per 1,000) using five predictors: LifeExp (life expectancy in years), InfMort (infant mortality rate), Density (population density per square kilometer), GDPCap (Gross Domestic Produ

Relationship between age-adjusted percent smoking & time

The estimated age-adjusted percent of persons 18 years of age and over who smoke cigarettes are shown below for females and males for selected years. Estimated Age-Adjusted Percent Smoking Cigarettes Year Female Male 1965 33.7 51.2 1974 16.9 42.8 1979 25.3 37 1985 22.5 32.2 199

Analyze Role of Researcher in Regression Analysis

At the heart of quantitative research is regression analysis. A regression model simply measures the association of two variables - variation: the dependent variable's observed value from its mean in relation to the independent variables observed value from its predicted value. I refer to this as 'variation of numbers in a col

Regression Analysis

The IRS wants to develop a method for deteting whether or not individuals have overstated their deductions for charitable contributions on their tax returns. To assist in this effort, the IRS supplied data found in the file Dat9-7.xlsx that accompanies this book listing the adjusted gross income (AGI) and charitable contribution

Correlation and Regression question

1- Refer to the following information to answer Questions A through D.To help gain a better understanding of the relationship between the return on the common stocks of small companies and the return on the S&P 500 Index, you run a simple linear regression to quantify this relationship using the monthly return on small stocks as

Predict used selling price based on mileage.

Please see attached file for figure. The Cadet is a popular model of sport utility vehicle, known for its relatively high resale value. The bivariate data given below were taken from a sample of sixteen Cadets, each bought new two years ago, and each sold used within the past month. For each Cadet in the sample, we have liste

ANOVA and Regression Analysis Project

See attachment for missing data tables. Assume that you are working on a team that has been commissioned by a large school district to collect and analyze data related to a recent curriculum experiment designed to improve student scores on state-wide standardized tests. The schools in this district are predominantly large, u

Hypothesis testing

Statistics Problems 1. Given: The paired sample data of the age and alcohol consumption of men result in a linear correlation coefficient close to 0. Conclusion: Older men tend to consume more alcohol than young men What is the error in the stated conclusion? 2. The eruption height and the time interval after erupt

Regression Analysis: Cost Vs Output

Describe each cost category as fixed or variable based upon the following simple regression results where cost is the dependent variable Y and output is the independent variable X. **See attached spreadsheet for formulas and applicable data** Output Cost1 ($) Cost2 ($) Cost3 ($) 0 17,000 11,000 0 100 10,000 7,000 1,000

Statistics Quiz

1)Go out and find at least 20 observations of ordered-pair data where one variable (X) is independent and (Y) is dependent. Here is my problem: Consider the following table, which contains measurements on two variables for ten people: the number of hours the person spent riding a bicycle in the past week and the number of mont

Regression Analysis: Incarceration Services of AIU data

See attached data file. First run a regression analysis using the Incarceration Services column of all data points in the AIU data set from Unit 1 as the independent variable and the Legal Services satisfaction column of all data points in the AIU data set as the dependent variable. Run a second regression analysis using t