A research group is conducting an experiment to study the relationship between fitness levels and the number of hours spent exercising each week. Subjects are randomly selected and, after several fitness tests, are assigned a fitness score. The number of hours spent exercising per week is also recorded. Data for 15 subjects are given below. Subject Hours of Exercise per Week Fitness Score 1 1 3 2 1.5 4.7 3 1.75 6 4 2 5 5 2 6.5 6 4.5 14.2 7 2.5 13.5 8 3.25 15 9 3 13.4 10 3.75 14 11 3.5 10 12 4 10 13 2.5 12 14 5.25 14.5 15 5 15 Create a bar graph in Microsoft® Excel® using the data. Label the graph and include the source of the data. Construct an equation in two variables that models this relationship. This equation may be linear, polynomial, rational, square root, or variation? Is the equation an exact model or an approximate model of the relationship between the variables? Explain your reasoning. Use the equation to make a prediction of the likely value of the dependent variable at points not included in the graph.
A research group is conducting
an experiment to study the relationship between fitness levels and the number
of hours spent exercising each week. Subjects are randomly selected and, after
several fitness tests, are assigned a fitness score. The number of hours spent
exercising per week is also recorded. Data for 15 subjects are given below.
Subject
Hours of Exercise per Week
Fitness Score
1
1
3
2
1.5
4.7
3
1.75
6
4
2
5
5
2
6.5
6
4.5
14.2
7
2.5
13.5
8
3.25
15
9
3
13.4
10
3.75
14
11
3.5
10
12
4
10
13
2.5
12
14
5.25
14.5
15
5
15
Create a bar graph in Microsoft® Excel® using
the data. Label the graph and include the source of the data. Construct an
equation in two variables that models this relationship. This equation may be
linear, polynomial, rational, square root, or variation?
Is the equation an exact model or an approximate model of
the relationship between the variables? Explain your reasoning.
Use the
equation to make a prediction of the likely value of the dependent variable at
points not included in the graph.
Step by step
Solved in 5 steps with 8 images
