Share
Explore BrainMass

Correlation and Regression Analysis

Solving and analyzing simple regression question

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. He randomly selects 6 months of data consisting of tire sales (in hundreds of tires) and advertising expenditures (in thousands of dollars). Base

Regression Analysis: Shoe Size & Weight

a) Construct a scatter plot for these data b) Using alpha = 0.10, test for the significance of the regression slope c) Construct a 90% confidence interval for the population slope. Shoe Size / Weight 7.5 / 7.2 8.0 / 7.8 9.0 / 8.0 8.5 /

Polynomials, Dummy Variables, and Joint F tests

I need some help following the instructions and creating a log file using Stata. Please download the do-file for this assignment Please submit: a) A printed Stata smcl (log) file documenting that you've completed each of the operations directed below and showing results. (NB: Be sure to run only your corrected Do file so

Logical Regression Questions

I need some help in basic regression questions about economics of education, the questions are based on a table enclosed in the attached file: a. In words, carefully explain and interpret the coefficient estimate for the treatment effect in Table 3, column 4. [2 points] b. Table 3 reports standard errors for the coeff

Sleepy Model and Snoozy Model: Regression

See the attached file. There are two prescription insomnia drugs in development. Below is the market research data. The most likely scenario for Product Sleepy is: Efficacy = 3, Safety = 4, Price = 2, Convenience = 4. The most likely scenario for Product Snoozy is: Efficacy = 5, Safety = 2, Price = 3,

Discussion on Causation, Correlation and Regression

I need some help in conceptualizing basic statistic concepts: (1)Briefly defines correlation and regression. (2) Compares (similarities) and contrasts (differences) regression and correlation. This is far different than the definitions required in (1) above. While definitions are important, they do not describe the similariti

Confidence Interval III

A chain of launderettes is investigating the lifetime of the washing machines that they use, measured in the number of washes completed before they need repairing. There are a number of machines used throughout their branches that have been installed at different times with each one having the number of completed washes recorded

Confidence interval calculation

A car manufacturer has redesigned the anti-theft device on one of its models to increase the time that it takes for a professional car thief to be able to steal the car. To determine the length of time that it takes it employs 30 reformed criminals to see how long it takes to steal the car. The sample has a mean time of 6 minute

Random Sample of Probationer's

This is the exact same question as I previously submitted; I believe I did not submit correct data for the question. (Random Sample of probationers data) I also attached previous work in case you need data. Thank you 5. You hypothesize that in a random sample of probationers, there is a relationship between a probationer's G

Correlation, Regression, and Comparing Means

Using the data set: Chamorro-Premuzic.sav; you will focus on the variables related to Extroversion and Agreeableness (student and lecturer) 1. Exploratory Data Analysis. a. Perform Exploratory Data Analysis on all variables in the data set. Because you are going to focus on Extroversion and Agreeableness, be sure to includ

Regression and Correlation

Examine relationship between GNP per capita and the percentage of respondents willing to pay more taxes. a. Create a table using the data below for the GNP per capita and the percentage willing to pay higher taxes. b. From the table that you created in (a), calculate a and b and write out the regression equation (i.e., predi

Methods of decretive statistics to summarize data

CASE 2- ALUMNI GIVING Alumni donations are an important source of revenue for colleges and universities. If administrators could determine the factors that could lead to increases in the percentage of alumni who make a donation, they might be able to implement policies that could lead to increased revenues. Research shows ha

Higher R-Square Value Prediction Intervals

QUESTION 1 1. A recent study by a major financial investment company was interested in determining whether the annual percentage change in stock price for companies is linearly related to the annual percent change in profits for the company. The following data was determined for 7 randomly selected companies: %change stock

Statistical Concepts of ANOVA, Samples, Chi-square, and Regression Equation

I need help answering these questions: e. Why is the F-distribution important? How do you determine if a significant difference exists among the groups in ANOVA? How do you determine differences between the groups in ANOVA? Provide an ANOVA example using either a personal or professional experience. f. What is an independen

Policy Memo on City of Kelsey

Need a policy memo that includes the following: (documents attached) - Use a correlation analysis to explain and a regression analysis to forecast the three major sources of Kelsey's tax revenue for the upcoming year. - Use the city's historical data on population as the independent variable and its major tax revenue receipts

Monte Carlo Simulation and Sensitivity Analysis

A decision maker is working on a problem that requires her to study the uncertainty surrounding the payoff of an investment. There are three possible levels of payoff -$1,000, $5,000, and $10,000. As a rough approximation, the decision maker believes that each possible payoff is equally likely. But she is not fully comfortable w

Relationship between seniority and days absent per year

15. A study is being made of the relationship between seniority, i.e., years of service with the company, and the number of workdays absent per year. The following table shows the relevant data for seven randomly selected employees. Years Employed (X) Days Absent Last Year (Y) 7 2 8

Regression Equations for Independent Variables

3. A regression equation uses three independent variables to predict Y. The coefficient of determination for regressing X_1 on variables X_2 and X_3 is .95. The coefficient of determination for regressing X_2 on variables X_1 and X_3 is .85. a. What is the VIF for X_1? b. What is the VIF for X_2? c. Would you say multicollin

Variables of interest to healthcare managers

Identify 5 variables of interest to healthcare managers. Select and define one variable and include your rationale for selecting this variable. What is the difference between a dependent and independent variable? Identify the population of interest. Describe the procedure for selecting the sample of the population.

Managing the Springville Herald

See the attached file. Managing the Springville Herald To ensure that as may trial subscriptions as possible are converted to regular subscriptions, the Herald marketing department works closely with the distribution department to accomplish a smooth initial delivery process for the trial subscription customers. To assist in

Converting a Monthly Trend into an Annual Trend

Suppose we have run a regression on 48 months of data and the regression equation is Y = 50000 + 1000*x (where x is the month number). What is the annual trend? Play with some numbers to convince yourself of your answer. Would this be 12000, why or why not? Please help!

The relationship between two variables: Example problem

Calculate, test, and interpret the relationship between two variables using the correlation coefficient. The following sample observations were randomly selected. X: 5 4 4 5 11 Y: 5 7 4 6 8 Picture Click here for the Excel Data File a. Determine the regression equation. (Round your answers to 3 decimal pl

Modelling and Drawing Equations from Data

The data in DJIA.xls (ExcelDataFiles) represents the closing value of the Dow Jones Industrial Average (DJIA) over the 29-year period from 1979 to 2007. Year | Coded Year | DJIA 1979 | 0 | 838.7 1980 | 1 | 964.0 1981 | 2 | 875.0 1982 | 3 | 1046.5 1983 | 4 | 1258.6 1984 | 5 | 1211.6 1985 | 6 | 1546.7 1986 | 7 | 1896.0

Profit Maximising Linear Programming Tutorial

Consider a problem where we two products: Product A (cloth bags) and product B (leather bags). Each unit of Product A that is sold produces $30 in profit and each unit of Product B that is sold produces $50 in profit. There are three resources involved (cloth, leather, and labor), and different quantities are required for each

Predicting the Number of Orders Based on the Weight of the Mail

The Data of Mail.XLS Weight Orders 216 6.1 283 9.1 237 7.2 203 7.5 259 6.9 374 11.5 342 10.3 301 9.5 365 9.2 384 10.6 404 12.5 426 12.9 482 14.5 432 13.6 409 12.8 553 16.5 572 17.1 506 15 528 16.2 501 15.8 628 19 677 19.4 602 19.1 630 18 652 20.2 The operations manager of a large mail-order house bel

Auto Industry Research Project Examples

I have to construct a paper with this criteria: as preparation for the final research paper, formulate a theory about the correlation between measurable independent variables (causes) and one measurable dependent variable (the effect). Be sure to have at least two independent variables for proposed research paper. How do I be

Determining Sales

Table: Sales Space 1.6 5 2.2 5 1.4 5 1.9 10 2.4 10 2.6 10 2.3 15 2.7 15 2.8 15 2.6 20 2.9 20 3.1 20 1. Find the y-intercept of the regression equation. a) 0.074 b) 7.4 c) 1.45 2. In the above problem, if the square fo

Statistics: Predicted Value of Cricket Chirps

Find the best predicted temperature (in degree F) at a time when a cricket chirps 3000 times in one minute. What is wrong with this predicted value? Chirps in 1 minute: 882, 1188, 1104, 864, 1200, 1032, 960, 900 Temperature (degree F) 69.7, 93.3, 84.3, 76.3, 88.6, 82.6, 71.6, 79.6

Developing a Trend Line

Develop a trend line for the demand for fertilizer using computer software. Data collected on the yearly demand for 50 pound bags of fertilizer at Wallace Garden Supply are shown in the following table: Year Demand for fertilizer (1000s of bags) 1 4 2 6 3 4 4 5 5 10 6 8 7 7 8 9 9 12 10 14 11 15.

Data Points Table

See the attached file. The data table below tabulates a pizza parlor's advertising expenditures and sales for 8 consecutive quarters. The marketing manager wants to know how much of an impact current advertising will have on sales two quarters from now. When running a regression with the dependent variable "sales" and the