Explore BrainMass

Explore BrainMass

    Regression Analysis

    BrainMass Solutions Available for Instant Download

    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

    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

    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

    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


    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

    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

    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