All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
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
Ask a Question
Search
Search
Sign In
Register
study help
mathematics
elementary statistics excel
Questions and Answers of
Elementary Statistics Excel
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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,
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
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
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,
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
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
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
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
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
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
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
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
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
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
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
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.
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
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 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
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
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
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
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
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
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
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
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
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
Showing 400 - 500
of 478
1
2
3
4
5