Explore BrainMass

Explore BrainMass

    Regression Analysis

    BrainMass Solutions Available for Instant Download

    Regression Equation and Standard Error of Estimate

    Mr. James McWhinney, president of Daniel-James Financial Services, believes there is a relationship between the number of client contacts and the dollar amount of sales. To document this assertion, Mr. McWhinney gathered the following sample information. The X column indicates the number of client contacts last month, and the Y

    Definition of statistical terms

    I. B0 (beta sub zero) = population intercept ii. B1 (beta sub one) = population slope iii. e (epsilon) = random error iv. r = coefficient of correlation v. r2 (r-squared) = coefficient of determination vi. Independent variable vii. Dependent variable

    Method for Correlation analysis

    I know the answer for the following problem is: r=0.62, df=8, not significant at .05 I am not sure how to get this answer. Please show all work. An urban sociologist interested in neighborliness collected data for a sample od 10 adults on (x) how many years they have lived in their neighborhood and (y) how many neighbors t

    Multiple Regression explanation

    I am working to develop an equation for Y that is based on up to 10 different X variables. I am trying multiple regression. What I need to know is what tests I run to determine the suitability of the model? For example how do I determine if simple, linear regression is suitable or if I need to try a different, non-linear form?

    Finding the Regression Line by using Excel

    A sales manager for an advertising agency believes there is a relationship between the number of contacts and the amount of sales. To verify this belief, the following data were collected: Salesperson # of Contacts Sales (000) 1 14 24 2 12 14 3 20 28 4 16 30 5 46 80 6 23 30 7 48 90 8 50 85 9 55 120 10

    Statistical Analysis of Diamond Data

    O Perform some quick research (likely on the web) to describe color, quality, and certification of diamonds. o Respond to the following (based on the data in the Excel file) and support each with some reference to a statistical tool or graphical analysis. (1) If someone wanted a large but inexpensive diamond, what col

    What is a predictor of blood pressure?

    The data below are the ages and systolic blood pressures of 9 randomly selected adults. Construct a scatter plot for the data. Find the equation of the regression line for the given data, linear correlation coefficient, r, and the coefficient of determination, r2,. Age x 38 41 45 48 51 53 57 61 65 Pressure y 116 1

    Statistics Questions

    1) If the Z-value is used to test a null hypothesis that the population mean equals a given number, large positive and negative values of Z will lead to a rejection of H0. TRUE OR FALSE. 2) In a two-tailed hypothesis (large sample), test the test statistic is determined to be -2.5. The p-value for this test is _____________ 3)

    Linear correlation analysis calculations

    Calculate the coefficient of determination, given that the linear correlation coefficient, r, is -0.625. What does this tell you about the explained variation and the unexplained variation of the data about the regression line?

    Economics - Demand Problems/Calculations

    Economics - Demand Problems/Calculations. See attached file for full problem description. 1. Assume you have to analyze the following data provided to you from the Accounting Department. a) From Column A and E in the demand schedule above, what is the price elasticity of demand when our price is between $1600 and $1450 per u

    LP Model/Surplus & Artificial Variables/Integer

    1. What are the assumptions and requirements for an LP model to be formulated and used? Under what conditions will an LP problem: be unbounded? be infeasible? have more than one optimal solution? 2. The administrator of a large hospital made the state, "I would like to use LP, but it's a technique that operates under co

    Problems on the Spearman rank correlation coefficient, statistical decision theory, multiple regression, Chi -Square, time series analysis, nonparametric statistics, quality control, etc.

    1. You are a corporate inspector for an organization with 10 manufacturing plants, and you are interested in determining how well each plant audit score correlates with injury experience. The individual plant audit scores and their injury frequency rates for the year, along with their respective rankings, are tabulated in the fo

    Multiple Regression Equations

    The following data give the yield, Y, per plot of land depending on the quantity of the fertilizer used, X1, and the number of inches of rainfall, X2. Compute the two equations that you would use to establish "y-hat" for this problem. Use formulas and show your work versus using a statistical software program. Yield per Plo

    Multiple regression analysis with the attached data

    1. Can I perform a multiple regression analysis with the attached data that I've collected without changing that data or adding to it? Please explain why or why not to help me understand. 2. Can I perform a multiple regression analysis with the attached data that I've collected and additional data derived from that collectio

    Regression Formula

    I'm not sure of how to use the regression formula correctly to compute a simple regression equation y = mx + b for the data that I attached. What would the approximate number of housing starts be at the following interest rates: 8.5%, 4.5%, 3.7%, 2.3% If I were the owner of a business in the housing construction sect


    Using Excel as your processing tool, work through three simple regression analyses. First run a regression analysis using the BENEFITS column of all data points in the AIU data set as the independent variable and the INTRINSIC job satisfaction column of all data points in the AIU data set as the dependent variable. Create a

    Regression analysis of annual sales based on advertising expense

    Reliable Furniture is a family business that has been selling to retail customers in the Chicago area for many years. They advertise extensively on radio and TV, emphasizing their low prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is informat


    Manatees are large, gentle sea creatures that live along the Florida coast. Many manatees are killed or injured by powerboats. Here are data on powerboat registrations (in thousands) and the number of manatees killed by boats in Florida in the years 1977 to 1987. (a) Which is the explanatory variable? Make a scatterplot of th

    Managerial Decision Making - Statistics Problem 1999

    The enrollment in the College of Business at Midwestern University by quarter since 1999 is: Quarter Year Winter Spring Summer Fall 1999 2,033 1,871 714 2,318 2000 2,174 2,069 840 2,413 2001 2,370 2,254 927 2,704 2002 2,625 2,478 1,136 3,001 2003 2,803 2,668 ? ? Using the ratio-to-moving-average method

    Least Squares Trend Estimation for Number of Employees

    See the attached file for full problem. The number of employees, in thousands, of Keller Overhead Door, Inc. for the years 1998 to 2003 are: Year Employees Year Employees 1998 45.6 2001 39.3 1999 42.2 2002 34.0 2000 41.1 2003 30.0 a. Plot the data. b. Determine the least squares trend equation. c. Use the t

    Predictions from Regression Equations

    Use the following sets of data to calculate the coefficient of determination, the total variation, explained variation, and unexplained variation. x 6 2 3 1 4 y 12 6 9 1 10

    Managerial Decision Making - Regression Analysis.

    A consumer buying cooperative tested the effective heating area of 20 different electric space heaters with different wattages. Here are the results. Heater Wattage Area 1 1,500 205 2 750 70 3 1,500 199 4 1,250 151 5 1,250 181 6 1,250 217 7 1,000 94 8 2,000 298 9 1,000 135 10

    Managerial Decision Making - Regression Analysis

    Suppose that the sales manager of a large automotive parts distributor wants to estimate as early as April the total annual sales of a region. On the basis of regional sales, the total sales for the company can also be estimated. If, based on past experience, it is found that the April estimates of annual sales are reasonably ac

    Steps of analysis of CIA data using regression and correlation analysis.

    Refer to the CIA data, which reports demographic and economic information on 46 countries. Let unemployment be the dependent variable and percent of the population over 65, life expectancy, and literacy be the independent variables. a. Determine the regression equation using a software package. Write out the regression equati

    Independent Variables

    See attached file for full problem description. Suppose that the sales manager of a company wishes to evaluate the performance of the company's sales representatives. Each sales representative is solely responsible for one sales territory, and the manager decides that it is reasonable to measure performance of a sales represe