Lernkarten
6. In a sample of 50 businesses in Liechtenstein, ten had between 10 and 19 employees; fourteen had between 20 and 29 employees; seventeen had between 30 and 39 employees; seven had between 40 and 49 employees; and two had between 50 and 59 employees.
a. Construct a Frequency Table for this data. Include columns for Frequency, Relative Frequency, Cumulative Frequency, and Cumulative Relative Frequency.
6. In a sample of 50 businesses in Liechtenstein, ten had between 10 and 19 employees; fourteen had between 20 and 29 employees; seventeen had between 30 and 39 employees; seven had between 40 and 49 employees; and two had between 50 and 59 employees.
b. Draw a bar chart for this data.
7. The following data are the number of automobiles sold last month by fifteen car dealers in Austria.
116 120 122 130 136 137 142 142 147 160 162 168 170 172 173
Construct a Stem-and-Leaf display for this data.
8. The following scatterplot contains twenty observations for two generic variables, “x” and “y”.
Based on this scatterplot, would you classify the relationship between x any y as being Positive, or Negative, or Null? Why?
There is a Negative relationship between “x” and “y”. Clearly “y” tends to decrease as “x” increases (that is, the two variables tend to move in opposite directions). Note: In this scatterplot I changed the value at which the horizontal axis and the vertical axis cross (i.e., the graph’s origin; it is not the “usual” x=0 and y=0), the minimum and maximum values of each axis, and the size of the gaps between tic marks on each axis. Sometimes you see that in real-world applications ... which is why I did it here!
9. The Excel data file “Tax Cost” (which is with the rest of this week’s stuff on Moodle) contains the cost paid by families to have their income taxes prepared in the USA. (Trust me, tax forms there can get very complicated....). Use Excel to calculate, and then explain and interpret, the following statistics:
a. Mean
a. Using the AVERAGE command in Excel (as per the lecture), we find the mean to be 160. On average, a family in our sample paid $160.00 to have their income taxes prepared.
9. The Excel data file “Tax Cost” (which is with the rest of this week’s stuff on Moodle) contains the cost paid by families to have their income taxes prepared in the USA. (Trust me, tax forms there can get very complicated....). Use Excel to calculate, and then explain and interpret, the following statistics:
b. Median
b. Using the MEDIAN command in Excel (as per the lecture), we find the median to be 135. One-half of the families paid less than $135, and the other half paid more than $135, to have their taxes prepared.
9. The Excel data file “Tax Cost” (which is with the rest of this week’s stuff on Moodle) contains the cost paid by families to have their income taxes prepared in the USA. (Trust me, tax forms there can get very complicated....). Use Excel to calculate, and then explain and interpret, the following statistics:
c. Mode
c. Using the MODE command in Excel (as per the lecture), we find the mode to be 120. The most common amount a family in our sample paid to have their taxes prepared is $120.
9. The Excel data file “Tax Cost” (which is with the rest of this week’s stuff on Moodle) contains the cost paid by families to have their income taxes prepared in the USA. (Trust me, tax forms there can get very complicated....). Use Excel to calculate, and then explain and interpret, the following statistics:
d. First Quartile
d. Using the QUARTILE command in Excel (as per the lecture), we find the first quartile (Q1) value to be 115. One-quarter (25%) of the families in our sample paid $115 or less to have their taxes prepared.
