Purchase Solution

Trend Line - Average Annual Hours of Work, Married Couple with Children

Not what you're looking for?

Ask Custom Question

See the attached file.

Prepare answers to Exercise 14.4 (page 621) of the Doane and Seward e-text as modified below.e-text as modified below.

Modifications: In Exercise 14.4 do items (a) for years 1990 through 1995, (b), then change item (c.) to fit only a linear trend, and do the following changes: (d) plot the trendline with the equation added using the options button, (e) predict 1998 and 1999 using the trendline equation and compare to the actual hours for 1998 & 1999, and (f) discuss the comparison of predicted value to actual value.

Use Excel to show all work.

Attachments
Purchase this Solution
Solution Summary

The solution describes how to plot a trend line with an equation and predict future values using the trend line equation.

Purchase this Solution
Free BrainMass Quizzes
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.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

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

View More Free Quizzes
Related BrainMass Solutions

  • Regression analysis

    (WorkHours) Average Annual Hours of Work, Married Couple with Children Year Hours Year Hours 1982 3,160 1991 3,515 1983 3,194 1992 3,491 1984 3,289 1993 3,536 1985 3,309 1994 3,589 1986 3,391 1995 3,616 1987 3,451

  • WidgeCorp's demographic reports

    Family 8,673 Married Couple Family w/ Children < 18 3,095 Married Couple Family w/ no own Children < 18 5,578 Attached is a document that will assist with your studies on this subject.

  • Algebra word problems

    The formula R =120n + 4000 gives her revenue in dollars for n hours of work. What is her revenue for 100 hours of work? What is her revenue for 101 hours of work? By how much did the one extra hour of work increase the revenue?

  • Mathematics - Linear Operators

    The formula R _ 120n _ 4000 gives her revenue in dollars for n hours of work. What is her revenue for 100 hours of work? What is her revenue for 101 hours of work? By how much did the one extra hour of work increase the revenue?

  • Linear Equations and Graphs

    The formula R = 120n + 4000 gives her revenue in dollars for n hours of work. What is her revenue for 100 hours of work? $16000 What is her revenue for 101 hours of work? $16120 By how much did the one extra hour of work increase the revenue?

  • Statistics Problem

    What is the estimated index of satisfaction for a person who first married at 18, has an annual income of $26,500, has three children living, has assets of $156,000, has an index of health status of 141, and has 2.5 social activities a week on the

  • Several Algebra Excercises

    The formula gives her revenue in dollars for n hours of work. What is her revenue for 100 hours of work? What is her revenue for 101 hours of work? By how much did the one extra hour of work increase the revenue?

  • Poverty in the United States

    -for children under age 6 living in families with a female householder and no husband present: 54.8 percent ? -for children under age 6 in married-couple families: 10.1 percent ? Poverty rate for African Americans: 26.1 percent ?

  • Step-wise answer to PERSONAL FINANCE

    239573 Step-wise answer to PERSONAL FINANCE 1 to 2 pages long Bernie and Pam Britten are a young married couple beginning careers and establishing a household.

View More Related Solutions