Using the data from question 1, create a frequency table and a
histogram in Microsoft® Excel®....
Using the data from question 1, create a frequency table and a
histogram in Microsoft® Excel®.
QUESTION 1 DATA- enter the following data from the 40
participants by first creating a variable labeled “Score”. Next,
compute the mean, median, and mode for the following set of 40
reading scores:
31
32
43
42
24
34
25
44
23
43
24
36
25
41
23
28
14
21
24
17
25
23
44
21
13
26
23
32
12
26
14...
Data set for ages of students in stats class:
17, 18, 18, 18, 18, 18, 18,...
Data set for ages of students in stats class:
17, 18, 18, 18, 18, 18, 18, 18, 18, 18, 18, 19, 19, 19, 19,19,
20, 20, 20, 21, 21, 21, 21, 21, 21, 22, 22, 22, 22, 23, 23, 23, 23,
24, 25, 25, 25, 26, 26, 27, 28, 28, 28, 28, 29, 29, 32, 36, 42
1) Compute the 5-number summary and create a modified box-plot,
using the inner-quartile range to identify any outliers.
Using Excel, create scatter plots and display the regression
equations for the following pairs of variables:...
Using Excel, create scatter plots and display the regression
equations for the following pairs of variables:
“BachDeg%” versus “Sales/SqFt”
In your report, include the scatter plots. For each scatter
plot, designate the type of relationship observed
(increasing/positive, decreasing/negative, or no relationship) and
determine what you can conclude from these relationships.
% w/ Bachelor's Degree (3 Miles)
Annual Sales Per Sq Ft
BachDeg%
Sales/SqFt
31
701.97
20
209.93
24
364.92
29
443.04
18
399.20
30
264.64
14
571.59
33
642.25
28...