Linear Regression

profileThman2c
au_com106_m3_spreadsheet_4.xls
Home>Mathematics homework help>Linear Regression

Sheet1

Exercise 1 With single formulas listed in answers 1, 2, & 3 below: Exercise 2 Exercise 3 Average Temperature per Month, per Year
1 Add the column of numbers January February March April May June July August September October November December
75 2 Calculate the median of this column 2004 21 32 43 54 65 76 87 98 75 60 50 32
87 3 Calculate the average of this column 2005 20 31 42 53 64 75 86 97 70 54 38 24
38 2006 25 25 40 50 59 60 72 70 59 48 37 26
90 2007 30 40 50 60 70 80 90 100 76 56 34 22
75 2008 19 20 43 54 70 79 88 89 54 54 34 19
12 2009 17 20 34 48 62 76 90 96 81 60 45 29
64 2010 20 34 48 62 76 90 92 88 67 45 20 18
35 Average
85
65 1 Add grid lines to this chart Example 1
78 2 Merge and Center the title across the months
96 3 Select the months on the chart and make the names of the month appear vertical, see example 1 May May
65 4 Make the months bolded text
45 5 Make the years bolded text
6 Make a 2D column chart including all of the months and the seven years worth of data
Answer 1 1 Make the entire block any shade of green with no lines 7 Create 12 formulas that will average each column's data
Answer 2 2 Select a few cells that are now green and make them white
Answer 3
Exercise 4
Using the Essay from the first assignment, calculate the following:
1 Create a formula that will tell you how many people are in the US if 1/4th of the people equals 57.7 million
2 Create a formula that will calculate the total number of people in the US next year
HINT: The increase in the total population is listed as a percentage under the "Workplace Statistics" heading
3 Using the list of all of the other things people would rather do than work with a therapist
a. List each thing a person would rather do, one thing per cell
b. List the percentage associated with each, underneath the thing they would rather do (see example 2)
c. Create a pie chart that graphically shows preferences to therapy
d. Insert this chart into the essay and submit both this worksheet and the essay
Example 2
Surfing Sky Diving Tennis Darts Insert data into the grid below from the essay
22% 30% 45% 3%

Sheet1

Surfing
Sky Diving
Tennis
Darts
0.22
0.3
0.45
0.03

Sheet2

Surfing Sky Diving Tennis Darts
22% 30% 45% 3%

Sheet2

Sheet3