Excel file answer some questions and some functions and show the working process.

Q1-Q25: Multiple Choice questions. Please put your answer in ROW 5 AND ROW 7. Each question is 1.5 points. Total points possible for Q1-Q25 = 1.5*25 = 37.5 You do NOT need to show your work process for multiple choice questions. Please only provide your final answer. Question Number Q1 Q2 Q3 Q4 Q5 Q6 Q7 Your Answer Question Number Q14 Q15 Q16 Q17 Q18 Q19 Q20 Your Answer Q1 Data are a. b. c. d. always numeric. always non-numeric. the raw material of statistics. always categorical. Q2 The entities on which data are collected are a. elements. b. populations. c. samples. d. observations. Q3 All the data collected in a particular study are referred to as the a. sample. b. variable. c. data set. d. population. Q4 In a questionnaire, respondents are asked to mark their marital status as single, married, divorced, or wi a. categorical b. quantitative c. interval-scale d. ordinal-scale Q5 A statistics professor asked students in a class their ages. Based on this information, the professor states a. an observational study. b. descriptive statistics. c. an experiment. d. statistical inference. Q6 A frequency distribution is a tabular summary of data showing the _____ of items in several classes. a. fraction b. percentage c. relative percentage d. number Q7 The percent frequency of a class is computed by a. multiplying the frequency by 100. b. c. d. dividing the relative frequency by 100. multiplying the relative frequency by 100. dividing the frequency by 100. Q8 The numbers of hours worked (per week) by 400 statistics students are shown below. Number Frequency of hours 0-9 20 10 – 19 80 20 – 29 200 30 – 39 100 The relative frequency of students working 0 – 9 hours per week is a. 0.05 b. 0.2 c. 0.25 d. 0.5 Q9 The measure of location which is the most likely to be influenced by extreme values in the data set is th a. range b. median c. mode d. mean Q10 The mean of the sample a. is always smaller than the mean of the population from which the sample was taken. b. can never be zero. c. can never be negative. d. can assume any value between the highest and the lowest value in the sample. Q11 The 50th percentile is the a. mode b. median c. mean d. midrange Q12 The variance of a sample of 100 observations equals 64. The standard deviation of the sample equals a. 8 b. 10 c. 4096 d. 10,000 Q13 Which of the following is a characteristic of an experiment where the binomial probability distribution a. The experiment has at least two possible outcomes b. Exactly two outcomes are possible on each trial c. The trials are dependent on each other d. The probabilities of the outcomes changes from one trial Q14 A continuous random variable may assume a. any numerical value in an interval or collection of intervals. b. finite number of values in a collection of intervals. c. an infinite sequence of values. d. only the positive integer values in an interval. Q15 The probability that Pete will catch fish when he goes fishing is .88. Pete is going to fish 3 days next w Hint: Use Excel function “BINOM.DIST” to solve this problem a. 0.88 b. 0.038 c. 0.04 d. 0.96 Q16 For a normal distribution, a positive value of z indicates that a. all the observations must have had positive values. b. the area corresponding to the z is either positive or negative. c. the sample mean is smaller than the population mean. d. the sample mean is larger than the population mean. Q17 Which of the following is not a characteristic of the normal probability distribution? a. The mean, median, and the mode are equal b. The mean of the distribution can be negative, zero, or positive c. The distribution is symmetrical d. The standard deviation must be 1 Q18 From a group of 12 students, we want to select a random sample of 5 students to serve on a university c Hint: use the Excel function “COMBIN” to solve this problem a. 60 b. 95,040 c. 25 d. 792 Q19 A simple random sample of 100 observations was taken from a large population. The sample mean and a. 0.5 b. 2 c. 5 d. 10 Q20 As the sample size becomes larger, the sampling distribution of the sample mean approaches a _____ d a. Binomial b. Poisson c. Normal d. Chi-square Q21 From a population with a variance of 484, a sample of 256 items is selected. At 95% confidence, the m a. 16 b. 1.375 c. d. 2.695 22 Q22 The z value for a 97.8% confidence interval estimation is Hint: Use the normal distribution table on your textbook or the Excel function “NORM.S.INV” to solve a. 2.02 b. 1.96 c. 2 d. 2.29 Q23 For a given sample size in hypothesis testing, a. the smaller the Type I error, the smaller the Type II error will be. b. the smaller the Type I error, the larger the Type II error will be c. Type II error will not be affected by Type I error d. the sum of Type I and Type II errors must equal to 1 Q24 The p -value is a probability that measures the support (or lack of support) for a. the null hypothesis b. the alternative hypothesis c. either the null or the alternative hypothesis d. neither the null nor the alternative hypothesis Q25 A weatherman stated that the average temperature during July in Chattanooga is 80 degrees or less. A s your final answer. Q8 Q9 Q10 Q11 Q12 Q21 Q22 Q23 Q24 Q25 Q13 ngle, married, divorced, or widowed. Marital status is an example of a(n) _____ variable. formation, the professor states that the average age of all the students in the university is 24 years. This is an example of of items in several classes. is going to fish 3 days next week. Define the random variable x to be the number of days Pete catches fish. The probability that Pete will ca ents to serve on a university committee. How many combinations of random samples of 5 students can be selected? ulation. The sample mean and the standard deviation were determined to be 50 and 5, respectively. The standard error of the mean is ooga is 80 degrees or less. A sample of 32 Julys is taken to test the weatherman’s statement. The correct set of hypotheses is h. The probability that Pete will catch fish on one day or less is Please provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. A cell with Excel function typed in is considered as “work shown”. Q26. A survey of 400 college seniors resulted in the following crosstabulation regarding their undergraduate major and whethe Undergraduate Major Graduate School Business Engineering Others Total Yes 35 42 63 140 No 91 104 65 260 Total 126 146 128 400 a. b. c. d. Are a majority of the seniors in the survey planning to attend graduate school? (2 points) Which discipline constitutes the majority of the individuals in the survey? (2 points) Compute row percentages and comment on the relationship between the students’ undergraduate major and their int Compute the column percentages and comment on the relationship between the students’ intention of going to gradu ndergraduate major and whether or not they plan to go to graduate school. (10 points) ents’ intention of going to graduate school and their undergraduate major. (3 points ) Please provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. A cell with Excel function typed in is considered as “work shown”. Q27. In a large university, 55% of the students are female. If a random sample of twenty students is selected, (10 points) a. what is the probability that the sample contains exactly four female students? (2 points) b. what is the probability that the sample will contain more than nine female students? (2 points) c. what is the probability that the sample will contain fewer than five female students? (3points) d. what is the expected number of female students? (3 points) n, you will receive ZERO point. dents is selected, (10 points) Please provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. A cell with Excel function typed in is considered as “work shown”. Q28. The salaries at a corporation are normally distributed with an average salary of $29,000 and a standard deviation of $3,00 a. What is the probability that an employee will have a salary between $22,520 and $33,480? (4 points) b. What is the probability that an employee will have a salary more than $31,880? (3 points) c. What is the probability that an employee will have a salary less than $28,440? (3 points) a standard deviation of $3,000. (10 points) Please provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. A cell with Excel function typed in is considered as “work shown”. Q29 The life expectancy in the United States is 78 with a standard deviation of 6 years. A random sample of 64 individuals is s a. Show the sampling distribution of the sample mean (what is the probability distribution? What are the parameters ( b. What is the probability that the sample mean will be larger than 80 years? (3 points) c. What is the probability that the sample mean will be less than 76.5 years? (3 points) d What is the probability that the sample mean will be between 76 and 82 years? (3 points) bution? What are the parameters (e.g. mean and standard deviation?)) (3 points) Please provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. A cell with Excel function typed in is considered as “work shown”. Q30. In order to determine the average weight of carry-on luggage by passengers in airplanes, a sample of 50 pieces of carry-on 20.5 pounds. Assume that we know the standard deviation of the population to be 6.25 pounds. Also, assume the population is a. Determine a 99% confidence interval estimate for the population mean weight of the carry-on luggage (4 points) b. Determine a 95% confidence interval estimate for the population mean weight of the carry-on luggage (4 points) c. Compare your answer for part a and part b, what do you find? (3 points) n, you will receive ZERO point. s, a sample of 50 pieces of carry-on luggage was collected and weighed. The average weight was ds. Also, assume the population is normally distributed. (11 points) the carry-on luggage (4 points) the carry-on luggage (4 points) Please provide your work process. If only a final answer is provided, without any work shown, you will receive ZERO point. A cell with Excel function typed in is considered as “work shown”. Q31. The average gasoline price of one of the major oil companies has been $2.20 per gallon. Because of cost reduction measu test this belief, we randomly selected a sample of 36 of the company’s gas stations and determined that the average price for the $0.12. (9.5 points ) a. State the null and the alternative hypotheses. (1.5 point) b. Compute the test statistic. (2 points) What is the p -value associated with the above sample results? (3 points ) c. Using α = .05, test the company’s claim and state your conclusion (3 points) d. n, you will receive ZERO point. . Because of cost reduction measures, it is believed that there has been a significant reduction in the average price. In order to mined that the average price for the stations in the sample was $2.14. Assume that the standard deviation of the population (σ) is age price. In order to of the population (σ) is

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.