Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 2, Problem 53SE
To determine
(a)
To Check:
Construct a cross tabulation with year founded and tuition and fees.
To determine
(b)
To Check:
Compute the row percentages for the cross tabulation.
To determine
(c)
To Check:
What relationship do you notice between year founded and tition fees.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A test consists of 10 questions made of 5 answers with only one correct answer. To pass the test, a student must answer at least 8 questions correctly. (a) If a student guesses on each question, what is the probability that the student passes the test? (b) Find the mean and standard deviation of the number of correct answers. (c) Is it unusual for a student to pass the test by guessing? Explain.
In a group of 40 people, 35% have never been abroad. Two people are selected at random without replacement and are asked about their past travel experience. a. Is this a binomial experiment? Why or why not? What is the probability that in a random sample of 2, no one has been abroad? b. What is the probability that in a random sample of 2, at least one has been abroad?
Questions
An insurance company's cumulative incurred claims for the last 5 accident years are given
in the following table:
Development Year
Accident Year 0
2018
1 2 3 4
245 267 274 289 292
2019
255 276 288 294
2020
265 283 292
2021
263 278
2022
271
It can be assumed that claims are fully run off after 4 years. The premiums received for
each year are:
Accident Year Premium
2018
306
2019
312
2020
318
2021
326
2022
330
You do not need to make any allowance for inflation.
1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method.
(b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method.
2. Comment on the differences in the reserves produced by the methods in Part 1.
Chapter 2 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Ch. 2.1 - The response to a question has three alternatives:...Ch. 2.1 - A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 - Prob. 4ECh. 2.1 - In alphabetical order, the six most common last...Ch. 2.1 - Nielsen Media Research provided the list of the 25...Ch. 2.1 - The Canmark Research Center Airport Customer...Ch. 2.1 - Prob. 8ECh. 2.1 - Nearly 1.8 million bachelor's degrees and over...Ch. 2.1 - VirtualTourist provides ratings for hotels...
Ch. 2.2 - Consider the following data. a. Develop a...Ch. 2.2 - Consider the following frequency distribution...Ch. 2.2 - Prob. 13ECh. 2.2 - Prob. 14ECh. 2.2 - Prob. 15ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - A doctor's office staff studied the waiting times...Ch. 2.2 - CBSSports.com developed the Total Player Ratings...Ch. 2.2 - Based on the tons handled in a year, the ports...Ch. 2.2 - The London School of Economics and the Harvard...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Entrepreneur magazine ranks franchises using...Ch. 2.2 - The following data show the year-to-date percent...Ch. 2.2 - Prob. 24ECh. 2.2 - Prob. 25ECh. 2.2 - The Flying Pig Half-Marathon (13.1 miles) had...Ch. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - The Daytona 500 is a 500-mile automobile race held...Ch. 2.3 - The following crosstabulation shows the average...Ch. 2.3 - Prob. 31ECh. 2.3 - The following crosstabulation shows the number of...Ch. 2.4 - Prob. 36ECh. 2.4 - Consider the following data on two categorical...Ch. 2.4 - Prob. 38ECh. 2.4 - Prob. 39ECh. 2.4 - Prob. 40ECh. 2.4 - Prob. 41ECh. 2.4 - Prob. 42ECh. 2.4 - The Northwest regional manager of an outdoor...Ch. 2 - Approximately 1.5 million high school students...Ch. 2 - Data showing the population by state in millions...Ch. 2 - A startup company's ability to gain funding is a...Ch. 2 - Prob. 49SECh. 2 - Prob. 50SECh. 2 - Western University has only one women's softball...Ch. 2 - Prob. 53SECh. 2 - Prob. 57SECh. 2 - A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Prob. 2.1.2CPCh. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 - Case Problem 2Motion Picture Industry The motion...Ch. 2 - Prob. 2.2.2CPCh. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 2 Motion Picture Industry The motion...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 3Queen City Cincinnati, Ohio, also...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...Ch. 2 - Case Problem 4Cut-Rate Machining, Inc. Jon...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall score for ten 13-inch models (Consumer Reports website, October 25, 2012). Brand & Model Price ($) Overall Score Samsung Ultrabook NP900X3C-A01US 1250 83 Apple MacBook Air MC965LL/A 1300 83 Apple MacBook Air MD231LL/A 1200 82 HP ENVY 13-2050nr Spectre XT 950 79 Sony VAIO SVS13112FXB 800 77 Acer Aspire S5-391-9880 Ultrabook 1200 74 Apple MacBook Pro MD101LL/A 1200 74 Apple MacBook Pro MD313LL/A 1000 73 Dell Inspiron I13Z-6591SLV 700 67 Samsung NP535U3C-A01US 600 63 a. Select a scatter diagram with price as the independent variable. b. What does the scatter diagram developed in part (a) indicate about the relationship…arrow_forwardTo the Internal Revenue Service, the reasonableness of total itemized deductions depends on the taxpayer’s adjusted gross income. Large deductions, which include charity and medical deductions, are more reasonable for taxpayers with large adjusted gross incomes. If a taxpayer claims larger than average itemized deductions for a given level of income, the chances of an IRS audit are increased. Data (in thousands of dollars) on adjusted gross income and the average or reasonable amount of itemized deductions follow. Adjusted Gross Income ($1000s) Reasonable Amount ofItemized Deductions ($1000s) 22 9.6 27 9.6 32 10.1 48 11.1 65 13.5 85 17.7 120 25.5 Compute b1 and b0 (to 4 decimals).b1 b0 Complete the estimated regression equation (to 2 decimals). = + x Predict a reasonable level of total itemized deductions for a taxpayer with an adjusted gross income of $52.5 thousand (to 2 decimals). thousand dollarsWhat is the value, in dollars, of…arrow_forwardK The mean height of women in a country (ages 20-29) is 63.7 inches. A random sample of 65 women in this age group is selected. What is the probability that the mean height for the sample is greater than 64 inches? Assume σ = 2.68. The probability that the mean height for the sample is greater than 64 inches is (Round to four decimal places as needed.)arrow_forward
- In a survey of a group of men, the heights in the 20-29 age group were normally distributed, with a mean of 69.6 inches and a standard deviation of 4.0 inches. A study participant is randomly selected. Complete parts (a) through (d) below. (a) Find the probability that a study participant has a height that is less than 68 inches. The probability that the study participant selected at random is less than 68 inches tall is 0.4. (Round to four decimal places as needed.) 20 2arrow_forwardPEER REPLY 1: Choose a classmate's Main Post and review their decision making process. 1. Choose a risk level for each of the states of nature (assign a probability value to each). 2. Explain why each risk level is chosen. 3. Which alternative do you believe would be the best based on the maximum EMV? 4. Do you feel determining the expected value with perfect information (EVWPI) is worthwhile in this situation? Why or why not?arrow_forwardQuestions An insurance company's cumulative incurred claims for the last 5 accident years are given in the following table: Development Year Accident Year 0 2018 1 2 3 4 245 267 274 289 292 2019 255 276 288 294 2020 265 283 292 2021 263 278 2022 271 It can be assumed that claims are fully run off after 4 years. The premiums received for each year are: Accident Year Premium 2018 306 2019 312 2020 318 2021 326 2022 330 You do not need to make any allowance for inflation. 1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method. (b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method. 2. Comment on the differences in the reserves produced by the methods in Part 1.arrow_forward
- You are provided with data that includes all 50 states of the United States. Your task is to draw a sample of: o 20 States using Random Sampling (2 points: 1 for random number generation; 1 for random sample) o 10 States using Systematic Sampling (4 points: 1 for random numbers generation; 1 for random sample different from the previous answer; 1 for correct K value calculation table; 1 for correct sample drawn by using systematic sampling) (For systematic sampling, do not use the original data directly. Instead, first randomize the data, and then use the randomized dataset to draw your sample. Furthermore, do not use the random list previously generated, instead, generate a new random sample for this part. For more details, please see the snapshot provided at the end.) Upload a Microsoft Excel file with two separate sheets. One sheet provides random sampling while the other provides systematic sampling. Excel snapshots that can help you in organizing columns are provided on the next…arrow_forwardThe population mean and standard deviation are given below. Find the required probability and determine whether the given sample mean would be considered unusual. For a sample of n = 65, find the probability of a sample mean being greater than 225 if μ = 224 and σ = 3.5. For a sample of n = 65, the probability of a sample mean being greater than 225 if μ=224 and σ = 3.5 is 0.0102 (Round to four decimal places as needed.)arrow_forward***Please do not just simply copy and paste the other solution for this problem posted on bartleby as that solution does not have all of the parts completed for this problem. Please answer this I will leave a like on the problem. The data needed to answer this question is given in the following link (file is on view only so if you would like to make a copy to make it easier for yourself feel free to do so) https://docs.google.com/spreadsheets/d/1aV5rsxdNjHnkeTkm5VqHzBXZgW-Ptbs3vqwk0SYiQPo/edit?usp=sharingarrow_forward
- The data needed to answer this question is given in the following link (file is on view only so if you would like to make a copy to make it easier for yourself feel free to do so) https://docs.google.com/spreadsheets/d/1aV5rsxdNjHnkeTkm5VqHzBXZgW-Ptbs3vqwk0SYiQPo/edit?usp=sharingarrow_forwardThe following relates to Problems 4 and 5. Christchurch, New Zealand experienced a major earthquake on February 22, 2011. It destroyed 100,000 homes. Data were collected on a sample of 300 damaged homes. These data are saved in the file called CIEG315 Homework 4 data.xlsx, which is available on Canvas under Files. A subset of the data is shown in the accompanying table. Two of the variables are qualitative in nature: Wall construction and roof construction. Two of the variables are quantitative: (1) Peak ground acceleration (PGA), a measure of the intensity of ground shaking that the home experienced in the earthquake (in units of acceleration of gravity, g); (2) Damage, which indicates the amount of damage experienced in the earthquake in New Zealand dollars; and (3) Building value, the pre-earthquake value of the home in New Zealand dollars. PGA (g) Damage (NZ$) Building Value (NZ$) Wall Construction Roof Construction Property ID 1 0.645 2 0.101 141,416 2,826 253,000 B 305,000 B T 3…arrow_forwardRose Par posted Apr 5, 2025 9:01 PM Subscribe To: Store Owner From: Rose Par, Manager Subject: Decision About Selling Custom Flower Bouquets Date: April 5, 2025 Our shop, which prides itself on selling handmade gifts and cultural items, has recently received inquiries from customers about the availability of fresh flower bouquets for special occasions. This has prompted me to consider whether we should introduce custom flower bouquets in our shop. We need to decide whether to start offering this new product. There are three options: provide a complete selection of custom bouquets for events like birthdays and anniversaries, start small with just a few ready-made flower arrangements, or do not add flowers. There are also three possible outcomes. First, we might see high demand, and the bouquets could sell quickly. Second, we might have medium demand, with a few sold each week. Third, there might be low demand, and the flowers may not sell well, possibly going to waste. These outcomes…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License