New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
mathematics
elementary statistics excel
Elementary Statistics Using Excel 6th Edition Mario F. Triola - Solutions
If we analyze the listed body temperatures with suitable methods of statistics, we conclude that when the differences are found between the 8 AM body temperatures and the 12 AM body temperatures, there is a 64% chance that the differences can be explained by random results obtained from populations
The New York State Department of Transportation evaluated the quality of the New York State Thruway by testing core samples collected at regular intervals of 1 mile.Identify which of these types of sampling is used: random, systematic, convenience, stratified, or cluster.
Students in a statistics class record the exact lengths of times that they surreptitiously use their smartphones during class.Determine whether the data are from a discrete or continuous data set.
In 1936, Literary Digest magazine mailed questionnaires to 10 million people and obtained 2,266,566 responses. The responses indicated that Alf Landon would win the presidential election. He didn’t.Identify which of these types of sampling is used: random, systematic, convenience, stratified, or
When studying the relationship between lengths of feet and heights so that footprint evidence at a crime scene can be used to estimate the height of the suspect, a researcher records the exact lengths of feet from a large sample of random subjects.Determine whether the data are from a discrete or
The listed body temperatures were obtained from Dr. Steven Wasserman, Dr. Philip Mackowiak, and Dr. Myron Levine, who were researchers at the University of Maryland. Is the source of the data likely to be biased? Refer to the sample of body temperatures (degrees Fahrenheit) in the table below.
A shift manager records the numbers of Corvettes manufactured during each day of production.Determine whether the data are from a discrete or continuous data set.
Refer to the table of body temperatures. Is there some meaningful way in which each body temperature recorded at 8 AM is matched with the 12 AM temperature? Refer to the sample of body temperatures (degrees Fahrenheit) in the table below. (The body temperatures are from a data set in Appendix
In a clinical trial of the cholesterol drug Lipitor (atorvastatin), subjects were partitioned into groups given a placebo or Lipitor doses of 10 mg, 20 mg, 40 mg, or 80 mg. The subjects were randomly assigned to the different treatment groups (based on data from Pfizer, Inc.).Identify which of
The Clerk of the U.S. House of Representatives records the number of representatives present at each session.Determine whether the data are from a discrete or continuous data set.
Most people have IQ scores between 70 and 130. For $39.99, you can purchase a PC or Mac program from High IQ Pro that is claimed to increase your IQ score by 10 to 20 points. The program claims to be “the only proven IQ increasing software in the brain training market,” but the author of your
Satellites are used to collect sample data for estimating deforestation rates. The Forest Resources Assessment of the United Nations (UN) Food and Agriculture Organization uses a method of selecting a sample of a 10-km-wide square at every 1o intersection of latitude and longitude.Identify which of
In a study of service times at a McDonald’s drive-up window, the numbers of cars serviced each hour of several days are recorded.Determine whether the data are from a discrete or continuous data set.
The author collected sample data by randomly selecting five books from each of the categories of science, fiction, and history. The numbers of pages in the books were then identified.Identify which of these types of sampling is used: random, systematic, convenience, stratified, or cluster.
a. Download the Excel data set files from www.TriolaStats.com and open the file 25 Fast Food.xlsx.b. In the Excel Ribbon, click the Data tab, and then click Data Analysis. (Be sure that the Data Analysis add-in has been installed as described in this section.)c. Click Descriptive Statistics, and
Among the subjects surveyed as part of the California Health Interview Survey (CHIS), several subjects are randomly selected and their heights are recorded.Determine whether the data are from a discrete or continuous data set.
In a study of treatments for back pain, 641 subjects were randomly assigned to the four different treatment groups of individualized acupuncture, standardized acupuncture, simulated acupuncture, and usual care (based on data from “A Randomized Trial Comparing Acupuncture, Simulated Acupuncture,
Using Excel’s Help feature, find a procedure for saving an Excel workbook (file) with a name that is di¥erent than the current name. What is that procedure?
In a study of weight gains by college students in their freshman year, researchers record the amounts of weight gained by randomly selected students (as in Data Set 6 “Freshman 15” in Appendix B).Determine whether the data are from a discrete or continuous data set.
A student of the author conducted a survey on driving habits by randomly selecting three different classes and surveying all of the students as they left those classes.Identify which of these types of sampling is used: random, systematic, convenience, stratified, or cluster.
Bear Measurements.xlsx (Data Set 9 in Appendix B) Download the Excel data set files from www.TriolaStats.com. Open and print the indicated Excel worksheet. Data set 9 AGE MONTH SEX (1 = M) 1 HEADLEN NECK LENGTH WEIGHT CHEST HEADWDTH 80 19 11.0 5.5 16.0 53.0 26.0 16.5 55 28.0 67.5 45.0 344 9.0 8.0
The average (mean) atomic weight of all elements in the periodic table is 134.355 unified atomic mass units.Identify whether the given value is a statistic or a parameter.
In a survey of smartphone ownership, the Pew Research Center randomly selected 1006 adults in the United States.Determine whether the sampling method appears to be sound or is flawed.
The author surveyed a sample from the population of his statistics class by identifying groups of males and females, then randomly selecting five students from each of those two groups.Identify which of these types of sampling is used: random, systematic, convenience, stratified, or cluster.
The given expressions are designed to yield results expressed in a form of scientific notation. For example, the displayed result of 1.23E5 can be expressed as 123,000, and the result of 1.23E-4 can be expressed as 0.000123. Perform the indicated operation and express the result as an ordinary
Use only the first five rows of data listed in Data Set 13 in Appendix B. Complete the following tasks in Excel. a. Create the described worksheet. b. Save the worksheet. c. Print a copy of the worksheet. d. Close the worksheet. e. Open the worksheet. f. Using the mouse, click the cell in the top
Foot and Height.xlsx (Data Set 2 in Appendix B) Download the Excel data set files from www.TriolaStats.com. Open and print the indicated Excel worksheet. Data Set 2 AGE SHOE PRINT 31.3 29.7 SHOE SIZE HEIGHT FOOT LENGTH SEX 67 27.8 11.0 180.3 175.3 M 47 25.7 9.0 11.0 41 26.7 31.3 184.8 25.9 31.8
A study was conducted of all 2223 passengers aboard the Titanic when it sank.Identify whether the given value is a statistic or a parameter.
In an AARP, Inc. survey of 1019 randomly selected adults, each was asked how much credit card debt he or she pays of each month.Determine whether the sampling method appears to be sound or is flawed.
In a Kelton Research poll, 1114 Americans 18 years of age or older were called after their telephone numbers were randomly generated by a computer, and 36% of the respondents said that they believe in the existence of UFOs.Identify which of these types of sampling is used: random, systematic,
Use only the first five rows of data listed in Data Set 8 in Appendix B. Complete the following tasks in Excel. a. Create the described worksheet. b. Save the worksheet. c. Print a copy of the worksheet. d. Close the worksheet. e. Open the worksheet. f. Using the mouse, click the cell in the top
The given expressions are designed to yield results expressed in a form of scientific notation. For example, the displayed result of 1.23E5 can be expressed as 123,000, and the result of 1.23E-4 can be expressed as 0.000123. Perform the indicated operation and express the result as an ordinary
In a statistical study, which of the following types of samples is generally best: convenience sample, voluntary response sample, simple random sample, biased sample?
M&M Weights.xlsx (Data Set 27 in Appendix B) Download the Excel data set files from www.TriolaStats.com. Open and print the indicated Excel worksheet. Data set 27 BLUE GREEN RED ORANGE BROWN YELLOW 0.925 0.751 0.735 0.881 0.696 0.883 0.876 0.841 0.895 0.769 0.863 0.914 0.859 0.856 0.775 0.881
Are the data described in Exercise 6 the result of an observational study or an experiment?Exercise 6In an AARP survey of 1019 randomly selected adults, the respondents were asked to identify the number of credit cards they have, and 26% of them said they had no credit cards. Is the value of 26% a
Use only the first five rows of data listed in Data Set 29 in Appendix B. Complete the following tasks in Excel. a. Create the described worksheet. b. Save the worksheet. c. Print a copy of the worksheet. d. Close the worksheet. e. Open the worksheet. f. Using the mouse, click the cell in the top
Refer to the survey described in Exercise 6. Because the 1019 subjects agreed to respond, do they constitute a voluntary response sample?Exercise 6In an AARP survey of 1019 randomly selected adults, the respondents were asked to identify the number of credit cards they have, and 26% of them said
In the same study cited in Exercise 1, birth weights of newborn babies are given in grams. Are these birth weights discrete data or continuous data?Exercise 1In a study of births in New York State, data were collected from four hospitals coded as follows:(1) Albany Medical Center; (1438) Bellevue
In the same study cited in the preceding exercise, 51% of the babies were girls.Identify whether the given value is a statistic or a parameter.
The sexuality of women was discussed in Shere Hite’s book Women and Love: A Cultural Revolution. Her conclusions were based on sample data that consisted of 4500 mailed responses from 100,000 questionnaires that were sent to women.Identify which of these types of sampling is used: random,
The given expressions are designed to yield results expressed in a form of scientific notation. For example, the displayed result of 1.23E5 can be expressed as 123,000, and the result of 1.23E-4 can be expressed as 0.000123. Perform the indicated operation and express the result as an ordinary
Types of Data In each of the following, identify the level of measurement of the sample data (nominal, ordinal, interval, ratio) and the type of sampling used to obtain the data (random, systematic, convenience, stratified, cluster).a. At Albany Medical Center, every 10th newborn baby is selected
In the Physicians’ Health Study, some of the subjects were treated with aspirin while others were given a placebo. For the subjects in this experiment, what is blinding?
Cola Weights and Volumes.xlsx (Data Set 26 in Appendix B) Download the Excel data set files from www.TriolaStats.com. Open and print the indicated Excel worksheet. Data set 26 COKE REG VOL 12.3 COKE REG WT PEPSI REG WT COKE DIET WT 0.7773 0.7758 COKE DIET VOL PEPSI REG VOL PEPSI DIET WT PEPSI
In a study of 400 babies born at four di¥erent hospitals in New York State, it was found that the average (mean) weight at birth was 3152.0 grams.Identify whether the given value is a statistic or a parameter.
In a survey of 1368 subjects, the following question was posted on the USA Today website: “In your view, are nuclear plants safe?” The survey subjects were Internet users who chose to respond to the question posted on the electronic edition of USA Today.Determine whether the sampling method
Cormorant bird population densities were studied by using the “line transect method” with aircraft observers flying along the shoreline of Lake Huron and collecting sample data at intervals of every 20 km (based on data from Journal of Great Lakes Research).Identify which of these types of
The given expressions are designed to yield results expressed in a form of scientific notation. For example, the displayed result of 1.23E5 can be expressed as 123,000, and the result of 1.23E-4 can be expressed as 0.000123. Perform the indicated operation and express the result as an ordinary
A deadly disaster in the United States was the Triangle Shirtwaist Factory Fire in New York City. A population of 146 garment workers died in that fire.Identify whether the given value is a statistic or a parameter.
According to the Census Bureau, the total number of housing units in the United States is 132,802,859.Identify whether the given value is a statistic or a parameter.
A data set in Appendix B includes brain volumes from 10 pairs of monozygotic (identical) twins. The data were collected by researchers at Harvard University, Massachusetts General Hospital, Dartmouth College, and the University of California at Davis.
The standard deviation is an extremely important concept introduced in Chapter 3. Using the sample data from Exercise 1 ?Birth Weights,? part of the calculation of the standard deviation is shown in the expression below. Evaluate this expression. (Fortunately, calculators and software are designed
In an AARP survey of 1019 randomly selected adults, the respondents were asked to identify the number of credit cards they have, and 26% of them said they had no credit cards. Is the value of 26% a statistic or a parameter?
A recent California Health Interview Survey (CHIS) included 2799 adolescent residents of California.Identify whether the given value is a statistic or a parameter.
Amounts of arsenic in samples of rice grown in Texas were measured by the Food and Drug Administration (FDA).
One way to get a very rough approximation of the value of a standard deviation of sample data is to find the range, then divide it by 4. The range is the difference between the highest sample value and the lowest sample value. In using this approach, what value is obtained from the sample data
Which of the following is>are simple random samples?a. As Lipitor pills are being manufactured, a quality control plan is to select every 500th pill and test it to confirm that it contains 80 mg of atorvastatin.b. To test for a gender difference in the way that men and women make online
Use Figure 1-6 included in this section. Complete the following tasks in Excel. a. Create the described worksheet. b. Save the worksheet. c. Print a copy of the worksheet. d. Close the worksheet. e. Open the worksheet. f. Using the mouse, click the cell in the top left corner of the worksheet,
Which of the following best describes the level of measurement of the birth weights described in Exercise 3: nominal, ordinal, interval, ratio?
On-time Flights In a study of American Airlines flights from JFK in New York to LAX in Los Angeles, 48 flights are randomly selected and the average (mean) arrival time is 8.9 minutes late.Identify whether the given value is a statistic or a parameter.
The Physicians Committee for Responsible Medicine tends to oppose the use of meat and dairy products in our diets, and that organization has received hundreds of thousands of dollars in funding from the Foundation to Support Animal Protection.Determine whether the given source has the potential to
The given expression is used to determine the size of the sample necessary to estimate the proportion of college students who have the profound wisdom to take a statistics course. Find the value and round the result to the nearest whole number. 1.962 . 0.25 0.032
One study showed that there is a very high correlation between the divorce rate in Maine and per capita consumption of margarine in the United States. Can we conclude that either one of those two variables is the cause of the other?
Are the birth weights described in Exercise 3 quantitative data or categorical data?
What is an Excel worksheet?
In a survey of 1020 adults in the United States, 44% said that they wash their hands after riding public transportation (based on data from KRC Research).a. Identify the sample and population.b. Is the value of 44% a statistic or parameter?c. What is the level of measurement of the value of 44%?
In what specific way was replication applied in the study cited in Exercise 1?
In “Cardiovascular Effects of Intravenous Triiodothyronine in Patients Undergoing Coronary Artery Bypass Graft Surgery” [Journal of the American Medical Association (JAMA), Vol. 275, No. 9], the authors explain that patients were assigned to one of three groups:(1) A group treated with
What is an Excel workbook?
The given expression is used for determining the likelihood that the average (mean) human body temperature is different from the value of 98.6oF that is commonly used. Find the given value and round the result to two decimal places. 98.2 – 98.6 0.62 V106
Robert Wadlow (1918?1940) is the tallest known person to have lived. The expression below converts his height of 272 cm to a standardized score. Find this value and round the result to two decimal places. Such standardized scores are considered to be significantly high if they are greater than 2 or
Which of the following best describes the level of measurement of the numbers 1, 1438, 66, and 413 from Exercise 1: nominal, ordinal, interval, ratio?
In Excel, what term is commonly used in place of the term “spreadsheet”?
Identify each of the following as quantitative data or categorical data.a. The platelet counts in Data Set 1 “Body Data” in Appendix Bb. The cigarette brands in Data Set 13 “Cigarette Contents” in Appendix Bc. The colors of the M&M candies in Data Set 27 “M&M Weights” in
Jule Cole is a founder of Mabel’s Labels, and she is the mother of six children. The probability that six randomly selected children are all girls is found by evaluating 0.56. Find that value.
In a study designed to test the effectiveness of paracetamol (or acetaminophen) as a treatment for lower back pain, 1643 patients were randomly assigned to one of three groups:(1) The 547 subjects in the placebo group were given pills containing no medication;(2) 550 subjects were in a group given
In an American Optometric Association survey, 1009 adults were randomly selected and asked to identify what they worry most about losing. 51% of the respondents chose “vision.” What’s wrong here?
In a study of births in New York State, data were collected from four hospitals coded as follows:(1) Albany Medical Center; (1438) Bellevue Hospital Center; (66) Olean General Hospital; (413) Strong Memorial Hospital. Does it make sense to calculate the average (mean) of the numbers 1, 1438, 66,
Showing 400 - 500
of 478
1
2
3
4
5
Step by Step Answers