QRC120                                           Group Activity 0

 

All group activities must include a signed statement from each group member that they participated fully in the assignment.

Please do the following at the beginning of every computer activity.

a. Open a new Word document.

b. Click on the "File" on the top menu bar, then go to "Save As".   Give your document a somewhat descriptive name (e.g. "Group Activity 1"). Also save the document to the desktop by setting the "Save in" textbox to "Desktop". (Saving to the desktop makes it easy to retrieve your work when you are finished.)

 

Note: All the tables can be found using the excel file Activity0.xls

 

 

1)  For the following, determine whether the function is linear and if so,   write the equation for the function.   Note ARC:   =(y2-y1)/(x2-x1)

 

x

y

ARC

x

y

ARC

5

-4

 

1

1

 

10

-1

 

2

3

 

15

2

 

5

9

 

20

5

 

7

13

 

 

 

x

y

ARC

x

y

ARC

2

1

 

2

20

 

7

5

 

4

13

 

9

11

 

6

6

 

12

17

 

8

-1

 

 

 

 

 

 

2)    a.  Determine if the data in Table 2.14 represents a linear function between values of blood alcohol concentration and number of drinks consumed for a 160-pound person.  (One drink is defined as 5oz of wine, 1.25 oz of 80-proof liquor, or 12 oz of beer.) 

           b.If the relationship is linear, determine the corresponding equation.

c. Determine the Blood Alcohol Concentration if that person has 12 drinks.  

 

D, Number of Drinks

A, Blood Alcohol Concentration

ARC

2

0.047

 

4

0.094

 

6

0.141

 

10

0.235

 

Table 2.14

 

 

 

 

 

 

 

 

3)    If a towns population in year 1 is 63,500 and declines at a constant rate of 700 people per year, construct a table that models the population from 1985-1989 and determine the corresponding equation to model its population size over time.  How long would it take for the population to drop to 53,000? 

 

 

Year

Population

 

0

 

 

1

63500

 

2

 

 

3

 

 

4