Purchase Solution

Decisions Based on Linear Relationships

Not what you're looking for?

Ask Custom Question

See the attached file.
Molly Prickett has just purchased a relatively small manufacturing company. The Company employs approximately 125 hourly workers, all performing essentially the same assembly-line operation. These non-unionized workers are concerned because they believe their wages for the past 21 years did not keep up with inflation. The Prickett data file give the average (hourly) wage for these people for the 21 years. Ms. Prickett has agreed to look at the wage pattern over the 21-year period. Her plans are to use the consumer price index-urban (CPI-U) to determine real wages for the 21 year period. The CPU data for the 21 years are given in the attached Excel file.

The CPU-U is based on prices of food, clothing, shelter, fuels, transportation and health care purchased for day-to-day living. Prices are collected in 85 areas across the U.S. from over 57,000 housing units and more than 19,000 establishments. To calculate the index, each item is assigned a weight corresponding to its relative importance in the consumer's budget.

Questions to answer:

1. Describe the problem at hand
2. Appropriate analytical tools to solve above problem
3. The pertinent results
4. Recommendation to the client (Molly Prickett)

I need this in Excel (regression output, scatterplot etc).

Attachments
Purchase this Solution
Solution Summary

Excel spreadsheet picks appropriate analytical tools and show the pertinent results, with recommendations for a client purchasing a manufacturing company.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Case study - health and sanitation-related supplies

    Regression Analysis, Moving Average, Nonlinear, Linear, Network and Integar? Explain why you would utilize the models you chose? We have to use linear model since all the relationships show linear relation. 9.

  • Quanitive Methods Analysis

    Linear programming is a model consisting of linear relationships representing a firm's decisions given an objective and resource constraints.

  • Using Linear Programming

    -Linear programming can also be used for many managerial decisions like in deciding product mix, make or buy decisions, media selection, marketing research, portfolio selection, shipping and transportation, etc.

  • Quantitative Reasoning Example Problem

    The decisions could be based on this information and whether to add less casual to the offering or more, whether to adjust pricing to meet the needs of customers in an economic effort to push sales.

  • Curriculum Theory

    Present a focus statement and have the students classify the data based on common attributes. Phase Four: Identifying Critical Relationships Phase Five: Exploring Relationships Phase Six: Making Inferences 3.

  • Linear programming, True false and Fill in the blanks

    Linear programming is a model consisting of linear relationships representing a firm's decisions given an objective and resource constraints. 2. The objective function is a linear relationship reflecting the objective of an operation. 3.

  • Statistical Tools

    This solution is comprised of an spreadsheet based computation of forecasting, linear equation, least-squares regression method, estimates, correlation coefficient, relationships and the coefficient of determination.

  • Significant Linear Relationship

    265247 Significant Linear Relationship The city of Denver wishes to see if there is a linear relationship between temperature and the amount of electricity used (in kilowatts) Based on the data below, is there a significant linear relationship between

  • Regression Model to Predict Accounts Receivable

    As the CFO you will employ linear regression analysis to arrive at visual presentation of the AR collection relationships and equations to predict collections for current, one month prior, and two months prior, based on the specified sales levels.

View More Related Solutions