Explore BrainMass

Explore BrainMass

    Correlation and Regression Analysis

    BrainMass Solutions Available for Instant Download

    Inferential Statistics and Regression Equation

    A computer utility was applied to the data collected in a study of generalized health index as a function of weight/height ratio, cholesterol and average nightly sleep. Part of the output is shown below. Find the regression equation. Predictor Coef SECoef T P constant 60 6.431 7

    Least-Squares Method and Coefficient of Determination

    The director of graduate studies at a large college of business would like to predict the grade point average (gpa) of students in an MBA program based on Graduate Management admission test (GMAT) scores. A sample of 20 students who had completed 2 years in the program is selected. The results are as follows: Observation G

    Analyzing the Relationship Between Time and Quality

    The data in the attached file is from a study conducted to examine the quality of fish after 7 days in ice storage. Ten fish of the same type and approximately the same size were caught and prepared for ice storage. Two of the fish were put in storage immediately after being caught, two were placed in storage 3 hours after be

    Pearson's Correlation Coefficient and Regression Equation

    The following table represents data involving direct labour costs (in Rands) and the batch size (in units) produced by a small manufacturing concern that specialises in a single product. BATCH SIZE (units) LABOUR COSTS (Rands) 15 200 18

    Logarithmic Trend Equation

    Can you please assist me with the question in the attachment? Thanks. 7. Sally's Software, Inc. is a rapidly growing supplier of computer software to the Sarasota area. Sales for the last five years are given below. Year Sales ($ millions) 1999 1.1 2000 1.5 2001 2.0 2002 2.4 2003 3.1 1. Determine the logarithmic tre

    Age of Boat Owners Analysis

    6. Assume next that the study of boat owners also produced information on the age of the owner. The data on age is as follows. (See Excel attachment for data and solution). a. Compute a multiple linear regression with statistical software. b. What would you expect the boat cost to be for a 35 yr old with 40,000 in income?

    Linear optimization using MS Excel Solver in practice prob

    Benz-Merc Cars produces four classes of cars: subcompact, compact, intermediate and luxury. BM also produces trucks and vans. Vendor capacities limit total production capacity to at most 1.2 million vehicles per year. Subcompacts and compacts are built together in a facility with a total annual capacity of 620,000 cars. Intermed

    Excel Problem

    Please help with the following problem. The problem is attached, it is number 19.2.11. For this problem, I have to do all the steps but I have to do it not just for the linear trend but also estimate the quadratic, exponential and auto-regressive. There are specific equations for those equations. If you need more information

    Racial Attitude and Socialization Study

    Assume that another counselor decided to extend the aforementioned study by collecting data on 14 children. His study yielded the following results: Racial Attitude and Preference Test Scores (X) 2 4 2 5 7 8 12 14 14 16 18 18 20 20 Racial Socialization Test Scores (Y) 4 6 8 10 14 12 14 11 16 10 12 6 6 4 Calculate and in

    Y Intercept

    A counselor is interested in determining if there is a relationship between children's scores on the racial attitude and preference test and their scores on the racial socialization test. She sampled a group of 10 children yielding the following results: Racial Attitude and Preference Test Scores (X) 8 7 9 5 10 2 5 7 6 12 R

    Determining least squares approximation

    The following table lists the annual amounts of glass cullet produced by Kimble Glass Works, Inc. Year Code Scrap (tons) 1999 1 2.0 2000 2 4.0 2001 3 3.0 2002 4 5.0 2003 5 6.0 Determine the least squares trend equation. Estimate the amount of scrap for the year 2005.

    Predict the mean grade for students who turn in papers

    Assume that the correlation is high enough to allow for reasonable prediction. The secretary of Gamma Gamma Gamma fraternity has done some research on the grading practices of Professor Neumann's classes, he has assembled the following data: mean weight of papers = 8.3 ounces, mean grade = 76.6, r = 0.84, and b = 5.8. Predict

    Forecast the stores total sales in Quarter 1 of 2009

    See attached file for full problem description. A retail jewelry store has generated the following regression model for forecasting its total quarterly sales (in thousands of dollars): Yt = 89.1 + 4.46t - 35.64Q1 - 17.82Q2 + 8.91Q3 Where Q1, Q2, and Q3 are indicator variables of the form Qi = 1 if the data are associat

    Identifying degrees of freedom and sum of squares

    See full problem description in attached. A company that manufactures computer chips wants to use a multiple regression model to study the effect that the variables x1 = daily production volume x2 = daily amount of time involved in production have on y = total daily production cost If a regression model is es

    Linear Programming Problem: The Friendly Family

    On their farm, the Friendly family grows apples that they harvest each fall and make into three products- apple butter, applesauce, and apple jelly. They sell these three items at several local grocery stores, at craft fairs in the region, and at their own Friendly Farm Pumpkin Festival for two weeks in October. Their three prim

    Exponential model for network growth

    I want you to locate data that can be effectively modeled using an exponential function. Check the scatterplot to be sure that your data is appropriate for an exponential model! Please include the following components: 1. A data table showing your original data, with a reference to the original source of the data. The refere

    Determine Least Squares Equation: Example Problem

    A company's net sales is $ million from 1993-2002, determine the least squares equation and based on this info, what are the estimated sales for 2005? 93 - 9,239 94 - 12,477 95 - 15,470 96 - 19,535 97 - 24,156 98 - 30,219 99 - 38,434 00 - 45,738 01 - 53,553 02 - 58,247

    Correlational research

    Briefly describe correlational research. Name a variable from the workplace that might prove to provide a correlational relationship and explain why you would choose these two?

    Variation and Prediction Interval for nicotine data

    1 Identifying total variation - What percentage of the total variation in nicotine can be explained by the linear relationship between tar and ? 2 Finding Prediction Interval for a given tar amount of 17 mg, identify the 95% prediction interval estimate of the amount of nicotine, and write a statement interpreting that inte

    Business Income After 6 Years

    Started plotting my business income 5 years ago in 1997. I do it quarterly because later on I want to check for the seasonal variation. My regression equation is: Income = $2300.00 + 150t t = time in quarters (3months = quarter) What kind of fortune (income) should I expect to rake in by the end of year 2003? This is a

    Solving for the correlational value

    This paragraph is from an article I am studying. I am suppose to know how to generate and explain a correlational value by this data. During the 10-month period during which these six exposures were detected, a total of 2,316 general anesthetics using isoflurane or desflurane were delivered in operating rooms monitored by ma

    Predicted Value and Regression Equation

    Four pairs of data yield r = 0.942 and the regression equation y-hat=3x. Also, y-ine =12.75. What is the best predicted value of y for x=2.6? (See attached file for better symbol representation).

    Regression Model to Forecast Monthly Sales of Beverage of a Year

    Let's say your company is considering branching out into cold beverages. You have been asked to come up with a regression model to forecast monthly sales of cold beverages for the next year. Think about what variables you might include in your model. Your manager asks for your thoughts.


    An econometrician is interested in evaluating the relation of demand for building materials to mortgage rates in Los Angles and San Francisco. He believes that the appropriate model is Y = 10 + 5X1 + 8X2 Where X1 = mortgage rate in % X2 = 1 if San Francisco, 0 if LA Y = demand in $100 per capita


    You decide to predict gasoline prices in different cities and towns in the U.S. for your term project. Your dependent variable is price of gasoline per gallon and your explanatory variables are per capita income, the number of firms that manufacture automobile parts in and around the city, the number of new business starts in th

    A manager of a product sales group believes the number of sales made by an employee (Y) depends on how many years that employee has been with the company (X1) and how he/she scored on a business

    A manager of a product sales group believes the number of sales made by an employee (Y) depends on how many years that employee has been with the company (X1) and how he/she scored on a business aptitude test (X2). A random sample of 8 employees provides the following: (see chart in attached file) Referring to table, if an