Explore BrainMass

# Regression Analysis

### Two chi-square tests and linear regression analysis

(5a) Collect observed and expected data. Perform a chi-square goodness-of-fit test (chi-square test for differences in more than two proportions). Test plan: Hypothesis statements: Population description: Description of how the random sample was drawn: Sample size: Expected and observed values: Type of test: Level

### Time series forecasting problem

Problem (see attached file) we are going time series techniques to predict non-retail sales for the next three months. Use the data in the file non retail time series for these exercises. 1. From the graph of the non retail sales data does there appear to be a seasonal component? If yes, what number of seasons do there a

### Regression line substitute x-bar

Regression line: substitute x-bar in and simplify = y bar. See attached file for full problem description. How would I prove that the regression line will always go through the point of means, e.g., prove that when I substitute in x bar for x in the equation, and simplify, i will get y bar as the answer.

### Solve: Hypothesis Testing and Regression Analysis

The null and alternate hypotheses are: H0: U1 = U2 H1: U1 does not = U2 A random sample of 15 observations from the first population revealed a sample mean of 350 and a sample standard deviation of 12. A random sample of 17 observations from the second population revealed a sample mean of 342 and a sample standard devia

### Correlation Analysis

45. Five observations taken for two variables follow X 4 6 11 3 16 i Y 50 50 40 60 30 i a. Develop a scatter diagram with x on the horizontal axis. b. What does the scatter diagram developed in part (a) indicate about the relationship between the two var

### Statistical Analysis on the National Assessment of Educational Progress

Is the educational achievement level of students related to how much the state in which they reside spends on education? In many communities this important question is being asked by taxpayers who are being asked by their school districts to increase the amount of tax revenue spent on education. In this case, you will be asked t

### Have NOx and DPM emissions been changing (decreasing or increasing) in OGV's, HDV's, or CHE's?

Identify a business research issue, problem, or opportunity facing an organization selected research issue, problem, or opportunity before completing your regression paper. Then, use the Internet or other resources to collect data pertaining to your selection. Prepare a 1,400-1,750-word paper examining a regression analysis on y

### Regression Statistics in Microsoft Excel

Identify a business research issue, problem, or opportunity facing an organization that can be examined using regression analysis. Describe the research issue, problem, or opportunity and the accompanying data. Then, perform a regression analysis on your data using Microsoft® Excel®. Finally, interpret the results of your regr

### Regression Analysis and ANOVA: significance tests, main effects and interactions, scatterplots, experimental design

Kindly generate necessary charts using Genstat software. Please complete Question 2 & 3 in attached document. See attached file for full problem description. ----------------------------------------------------------------------------- Question 2 An experiment was carried out to investigate the effect of three fact

### Least Square Method

See attached files for full problem description. 31. The following cross tabulation shows household income by education level of the head of household. Household Income (1000s) Under 25.0- 50.0- 75.0- 100 or Education level 25 49.9 74.9

### Generate a forecast for the total dollar sales the company can expect to receive

The monthly sales volume (in thousands of dollars) for a manufacturer of snow skis is seasonal (there tend to be more skis sold during fall and winter months than during warmer months). The following table shows the monthly seasonal indexes for the company's sales: JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC 1.22 1.04 0.8

### Regression analysis problem

You are the manager of the PSC marina on the Missouri River. From observations in the past, you think there is a direct link between the river level and the amount of fuel you sell. As the level rises, your sales increase, and as it decreases, your sales decline. The owner of the marina just took a statistics class at Peru S

### Predicting forecast based on given trend line equation

The following time series data represent the yearly amounts spent on advertising (in millions of dollars) by a large toy company: 23.3, 21.7, 22.7, 25.5, 22.7, 25.9 This series of data begins in year 1997(i.e., time period t=1 corresponds to 1997). Using regression analysis, a linear trend line of the form Tt=21.77 + 0.53

### Calculation of Slope, Intercept, Correlation, Residual, R Square, Coefficient of Determination and Regression Coefficients

This team exercise uses the data in the file HospLab. (notice the 2 worksheet tabs in the excel file) There are three independent variables. The objective is to determine the best individual variable or combination of variables to predict the number of hours of labor needed. With three independent variables there are seven

### Regression Analysis in Excel: Case Study using AIU Data

Using Excel as your processing tool, work through three simple regression analyses. For each, make a graph, determine the equation of the regression line, and find the r-squared value. First run a regression analysis using the BENEFITS column of 288 data points in the AIU data set as the independent variable and the INTRINS

### Regression Analysis of 288 Data Points

First run a regression analysis using the BENEFITS column of 288 data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of 288 data points in the AIU data set as the dependent variable. Create a graph with the trendline displayed. What is the least squares regression line equation?

### Estimate of Investment Earnings

Joe is being audited by the IRS and must provide an estimate for his investment earnings over the next four years.After a thorough search, Joe can only find the following records. Show how Joe can provide a reasonable estimate for 2007 - 2010. Year Earnings 1997 \$2,000 1998 \$3,000 2000 \$10,000 2003 \$12,000

### Statistics

Car dealership chain owner wants to increase the car sales of his chain. He wants to determine which factors influence the sales performance. Owner thinks that the following factors have a significant impact on sales performance: X1 = number of years of experience as a car sales person X2 = age Sales performance is meas

### Calculation of Chi Square test. Test of Independence, 95% confidence, customer quality rating, Linear regression, Slope, R square

David Gallano, a wine merchant, has collected opinions on grape wine quality from a sample of his customers. These customers tasted wine made from grapes grown in three regions of the country. They rated the wine quality on a scale of 1 (best) to 4 (worst). The following is the data obtained for customer quality rating of win

### Scatter diagram of rust data.

For a number of chondrites, the age and type (Type I or Type II) were noted, and the rust component was measured (rust.txt). (a) Draw a scatter diagram according to the type I and II and interpret it. (b) Does rustiness depend on age? (c) A further question is whether there is a difference between the two types of chond

### Test of significance for binary regression models

Test of significance for binary regression models: I have estimated both probit and logit regression models, and I want to check to see if a particular result is significant. Specifically speaking I want to test to determine whether or not V9 and V31 are significant. Please show me how to conduct such a test. Here is a sam

### Calculation of Correlation matrix, Scatter Plot matrix and Forward Stepwise regression model in SPSS

The attached XML file is a tiny dataset you can import to Stata or SAS. You don't have to send back your Stata/SAS output to me if you don't want to. 1. Create a scatterplot matrix - which variables seem related to the response variable? 2. Interpret a correlation matrix 3. Find the best (first-order) model considering sev

### SPSS Logistic Regression

I have a set of data and I'm running logistic regression using s.p.s.s. I'm getting great results but when i try to run the formula ((e^(b0+b1*x1...bi*xi))/(1+e^(bo+b1*x1....bi*xi)) on excel I'm getting bad result. Can you help me to figure out whats going on here and why I don't get the right result on the excel? Can you sh

### Multiple regression analysis with Excel

Do a multiple regression analysis for the following data in Excel where Selling Price is the dependent variable. Paste the results into a Word document. Below the output, write your hypotheses, decision and conclusion. Then highlight or circle the adjusted R2, the regression equation (or coefficients in Excel), the standard err

### Forecasting Problem: Regression Model

For all exercises indicate the specific values from the model that you are using to draw your conclusions. No credit will be given for just yes or no answers. 1. Develop the regression model to forecast retail sales from non-retail sales. a) Show the scatter diagram graph of the data and on the graph show the regression li

### Time series forecasting (seasonalized and deseasonalized)

A) Plot the data in 1982 dollars and find the least-squares trend line. What fraction of the variability in revenue is accounted for by the trend alone? B) Find the quarterly seasonal indices for the revenues in 1982 dollars, and use them to deseasonalize those revenues. C) Find the least-squares trend line for the deseas

### Recommendations regarding Cinergy's coal allocation problem

Prepare a report that summarizes your recommendations regarding Cinergy's coal allocation problem. Be sure to include information and analysis for the following issues. 1. Determine how much coal to purchase from each of the mining companies and how it should be allocated to the generating units. What is the cost to purchase,

### Regression Analysis in Genstat

Kindly explain in detail how to solve the problems using Genstat to generate the necessary graphs/charts. Please provide exact information on what are the commands to input inorder to generate the graphs/charts required. Kindly interpret the graphs/charts (given title, x & y axis description)and provide clear and concise expl

### Sales Forecasting: Forecast the sales for the home improvements market for Mexico City for 2007 using expenditures per household as the explanatory (independent) variable in a linear regression analysis. Graph the actual and forecasted data. See attached for data.

Forecast the sales for the home improvements market for Mexico City for 2007 using expenditures per household as the explanatory (independent) variable in a linear regression analysis. Graph the actual and forecasted data. See attached for data. Select another possible explanatory variable, in addition to expenditures per hou

### Regression Analysis on Phase V

Regression Analysis Problem. Answer the following questions based on the above table. A. How many houses were sold last week? n = _________? B. What is the dependent variable? Size of homes or selling prices? _____________________ C. What is the independent variable? Size of homes or selling p