Week 2 Test: Key Statistics Concepts and Excel Applications

Week 2 Test Victoria Jones (username: 4192747) Attempt 2 Written: May 14, 2023 5:31 AM - May 14, 2023 6:29 AM Submission View Your quiz has been submitted successfully. 1 / 1 point Twenty-five randomly selected students were asked the number of movies they watched the previous week. The results are as follows: See Attached Excel for Data. movie data.xlsx Find the approximate sample standard deviation, s. Use the Excel function to find the Sample SD. Round to two decimal places. ___1.12 ___ . 1 / 1 point The lengths (in kilometers) of rivers on the South Island of New Zealand that flow to the Tasman Sea are listed below. Find the variance. See Attached Excel for Data. Use the Excel function to find the Variance. river length data.xlsx 7.10 1057.58 32.52 1107.94 33.29 View question 2 feedback 0 / 1 point A sample of 8 cats found the following weights in kg. What is the variance? See Attached Excel for Data. Use the Excel function to find the Variance.

cat weight data.xlsx 0.9 0.087 0.076 0.104 0.295 View question 3 feedback 1 / 1 point To determine if Reiki is an effective method for treating pain, a pilot study was carried out where a certified second-degree Reiki therapist provided treatment on volunteers. Pain was measured using a visual analogue scale (VAS) immediately before and after the Reiki treatment (Olson & Hanson, 1997). Higher numbers mean the patients had more pain. Use the box-and-whiskers plots to determine the IQR for the before treatment measurements. Enter your response in the space below. Do Not Round. IQR= ___4 ___ 1 / 1 point

A survey was conducted of 130 purchasers of new BMW 3 series cars, 130 purchasers of new BMW 5 series cars, and 130 purchasers of new BMW 7 series cars. In it, people were asked the age they were when they purchased their car. The following box plots display the results. Which group is most likely to have an outlier? BMW 5 Series BMW 7 Series BMW 3 Series None of these groups Question 6 1 / 1 point Match each word with the description. cy 1 . shows the proportion of data points that have each value 2 . tells the number of data points that have each value Suppose one hundred eleven people who shopped in a special t-shirt store were asked the number of t-shirts they own costing more than $19 each.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

The percentage of all people who own at most three t-shirts costing more than $19 each is approximately: 40.5% Cannot be determined 20.7% 59% View question 7 feedback 1 / 1 point The lengths (in kilometers) of rivers on the South Island of New Zealand that flow to the Tasman Sea are listed below. Find the median. See Attached Excel for Data. river length data.xlsx 66.34 km 65.18 km 67.68 km 64 km 56 km View question 8 feedback 1 / 1 point The lengths (in kilometers) of rivers on the South Island of New Zealand that flow to the Tasman Sea are listed below. Find the mode. See Attached Excel for Data.

river length data.xlsx 56 & 64 32 no mode 64 56 View question 9 feedback 1 / 1 point The median can also be described as: the middle observation when the data values are arranged in ascending order the second quartile the 50th percentile all of the above Question 11 1 / 1 point The following data show the height (in inches) of a sample of students. See Attached Excel for Data. height data.xlsx The median height of these students is ___64 ___ inches. Do Not Round. 1 / 1 point Cholesterol levels were collected from patients two days after they had a heart attack (Ryan, Joiner & Ryan, Jr, 1985). Use Excel to find the 25th percentile. Round your answer to one decimal place. See Attached Excel for Data. cholesterol data.xlsx Answer= ___225.5 ___ Hint: Use =PERCENTILE.INC function in Excel.

Retrieved from http://www.statsci.org/data/general/cholest.html . 1 / 1 point Cholesterol levels were collected from patients two days after they had a heart attack (Ryan, Joiner & Ryan, Jr , 1985). Use Excel to find Q3. Do not include any decimals. See Attached Excel for Data. cholesterol data.xlsx Use the Excel function =PERCENTILE.INC to find Q3. Retrieved from http://www.statsci.org/data/general/cholest.html . Fill in each the value below: Q3 ___282 ___ 0 / 1 point Jesse was ranked 36th in his graduating class of 180 students. At what percentile is Jesse's ranking? 57th percentile 63rd percentile 20th percentile 80th percentile View question 14 feedback 1 / 1 point The following data represents the percent change in tuition levels at public, four-year colleges (inflation adjusted) from 2008 to 2013 (Weissmann, 2013). Below is the frequency distribution and ogive.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Class Limits Cumulative Frequency 2.2 – 11.7 6 11.8 – 21.3 26 21.4 – 30.9 37

31.0 – 40.5 41 40.6 – 50.1 43 50.2 – 59.7 45 59.8 – 69.3 48 69.4 – 78.9 50 Based on the information, what is the cumulative relative frequency for the 50.2% – 59.7% change in tuition class? 90 55 2 45 View question 15 feedback 1 / 1 point The following graph represents a random sample of car models driven by college students. What was the most common car model?

Chevy Both Nissan and Toyota Both Honda and Nissan Other Both Chevy and Toyota Toyota Nissan Question 17 1 / 1 point A scatter plot would be useful for Showing the relative number of sales of four different brands of blank DVDs Showing the top selling brands of blank DVDs Showing the trend of sales, over time, of five different brands of blank DVDs Showing the relationship between the sales of blank CDs and blank DVDs Question 18 1 / 1 point When an anthropologist finds skeletal remains, they need to figure out the height of the person. The height of a person (in cm) and the length of one of their metacarpal bone (in cm) were collected and shown in the table below. Create a scatter plot using Excel. height and length data.xlsx What type of a relationship, if any, exists between the height of a person and the length of their metacarpal? (2013, September 26). Retrieved from http://www.statsci.org/data/general/stature.html . Length of Metacarpal Height of Person 45 171 51 178 39 157

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Length of Metacarpal Height of Person 41 163 48 172 49 183 46 173 43 175 47 173 Positive No relationship Negative Question 19 1 / 1 point The following data show the height (in inches) of sample of students. 67 70 71 61 71 67 69 68 66 65 67 67 64 71 69 67 67 64 62 69 Create a stem leaf plot for these data and then select all of the correct statements about these data based on your plot. 50% of students have height less than 65 inches The maximum height observed is 67 inches More students have height of 65 inches or more The maximum observed height is 71 inches None of these are correct View question 19 feedback 0.666 / 1 point The following data show the amount (in ounces) of beverage in randomly selected 16-ounce beverage cans. Create a Stem-Leaf plot for these data. 15.8 16.1 15.2 14.8 15.8 15.9 16.0 15.5 16.1 15.7

Fill in the blanks of table below to complete the Stem-Leaf plot for these data. The key is 15|2 = 15.2. Sort the values for Leaf in increasing order and do not keep spaces or commas between leaves. Ste m Leaf 14 15 16 (a) (b) (c) (a): ___8 ___ (33.3 %) (b): ___257889 ___ (33.3 %) (c): ___0011 ___ (011)

MATH302 WEEK 2 TEST

Related Documents