Question 1126223: 8. This question is to give you practice at using Excel to input data, draw a scatterplot and include a linear line of best fit for your data. Directions for doing this will vary depending on whether you have Excel 2010 or Excel 2013. Instructions can be accessed on the internet by searching for ‘Drawing scatterplots in Excel’ on Google.
If you do not have access to Excel you may draw the graph by hand.
The following table shows the results of an experiment on 20 male volunteers to determine the relationship between the amount of alcohol in the blood (measured in mg/100 ml) and an individuals time to make a decision on a certain task (measured in milliseconds).
Alcohol(mg/ ml)
0
0
8
12
15
17
20
23
25
44
Time (ms)
790
760
790
840
835
830
855
860
855
875
Alcohol(mg/ ml)
48
51
51
57
61
70
73
74
76
81
Time (ms)
865
880
860
885
900
885
870
965
970
950
a. Draw a scatter plot of BAC versus decision time. Ensure that the graph is correctly labelled. The graph should be at least half an A4 page in size. The Time scale should start at 700 ms rather than zero (right click on the axis in your excel graph).
b. Add a ‘line of best fit’ or what Excel calls a ‘trendline’ to your graph.
c. Comment on the trend between BAC and reaction time and the implications when driving a vehicle.
Note – although this data is fictional, studies have shown similar trends.
Answer by ikleyn(52898)   (Show Source):
You can put this solution on YOUR website! .
Hey,
what do you expect from me and, more general, from us, the tutors, by posting this ?
Do you expect that we will start making this exercise ?
We will not do it - we do not need it - you, probably, need it.
Or do you expect that we will learn from the Internet on how to do it and then will retell it to you ?
100% guarantee that no one tutor at this forum will do it for you.
It is the assignment which you need to do ON YOUR OWN.
Since it is ABSOLUTELY CLEAR, I do not see any subject in this post to discuss it further in more details.
|
|
|
