All Related Questions of Business Analytics

Q: In each chapter of this book, we use a a fictitious

In each chapter of this book, we use a a fictitious company, Performance Lawn Equipment (PLE), within a case exercise for applying the tools and techniques introduced in the chapter.31 To put the case...

Q: Elizabeth Burke wants to develop a model to more effectively plan production

Elizabeth Burke wants to develop a model to more effectively plan production for the next year. Currently, PLE has a planned capacity of producing 9,100 mowers each month, which is approximately the a...

Q: The Data worksheet in the Excel file Airport Service Times lists a

The Data worksheet in the Excel file Airport Service Times lists a large sample of the time in seconds to process customers at a ticket counter. The second worksheet shows a frequency distribution and...

Q: Construct a frequency distribution for education in the Excel file Voter.

Construct a frequency distribution for education in the Excel file Voter. Develop a table to estimate the sample mean and sample variance using formulas. Check your results using Excel functions with...

Q: we asked you to use the Histogram tool to construct frequency distributions

we asked you to use the Histogram tool to construct frequency distributions and histograms for weekly usage and waiting time in the Excel file Car Sharing Report without grouping the data into bins....

Q: The amount of time it took 25 respondents to solve a particular

The amount of time it took 25 respondents to solve a particular task has been recorded in the following table: Develop a table to estimate the sample mean and sample standard deviation of the time usi...

Q: A teacher recorded the amount of time taken by 21 students to

A teacher recorded the amount of time taken by 21 students to complete a sprint race, to the nearest second, as follows: ■ Two students: between 51 and less than 56 seconds ■ Seven students: between 5...

Q: In the Excel file Postal Services, find the proportion of the

In the Excel file Postal Services, find the proportion of the number of items delivered to Portland, New York, and Chicago for six days in four consecutive weeks.

Q: Create a PivotTable to find the mean and standard deviation of the

Create a PivotTable to find the mean and standard deviation of the amount of travel expenses for each sales representative in the Excel file Travel Expenses.

Q: The Excel file Sample Sales provides sample data on the sales representatives’

The Excel file Sample Sales provides sample data on the sales representatives’ record. Create a PivotTable to find the following: a. Cross-tabulation of region versus item. b. Mean units, unit cost, a...

Q: Use a PivotTable to find the mean annual income by level of

Use a PivotTable to find the mean annual income by level of education for the data in the Excel file Education and Income.

Q: In the Excel file Debt and Retirement Savings, use a PivotTable

In the Excel file Debt and Retirement Savings, use a PivotTable to find the mean and standard deviation of income, long-term debt, and retirement savings for both single and married individuals.

Q: The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to

The CFO at Performance Lawn Equipment, Brian Ferguson, wishes to design a minimum variance portfolio of index funds to invest some of the firm’s cash reserves. The funds selected for...

Q: Using PivotTables, find the mean and standard deviation of sales by

Using PivotTables, find the mean and standard deviation of sales by region in the Sales Transactions database.

Q: Use the Excel file Graduation Employment to analyze the average salary and

Use the Excel file Graduation Employment to analyze the average salary and the average percentage of failure rate in interviews among the graduates from the different colleges. What conclusions do you...

Q: For the Peoples Choice Bank database, use PivotTables to find the

For the Peoples Choice Bank database, use PivotTables to find the average transaction amount for each account and branch.

Q: Find the correlation between weekly food expenditure and monthly household income in

Find the correlation between weekly food expenditure and monthly household income in the Excel file Food Expenditure.

Q: Use the Excel file Test Scores and Sales, developed by nine

Use the Excel file Test Scores and Sales, developed by nine salespersons during the past year, to find the coefficient of correlation between the test scores and sales.

Q: The Excel file House Sales lists a sample of the area (

The Excel file House Sales lists a sample of the area (in sq. ft) and prices (in dollars) of various houses. Compute the covariance and correlation between the area and prices.

Q: For the Excel file TV Viewing Survey, is there a significant

For the Excel file TV Viewing Survey, is there a significant correlation between (1) the number of TVs in a home and the hours of viewing per week, and (2) age and hours of viewing per week?

Q: Suppose that the average height of all professional basketball players is 6

Suppose that the average height of all professional basketball players is 6 feet with standard deviation of 5 feet. A player of interest to you is 5.5 feet. Would you consider this player as the outli...

Q: Use the following approaches to analyze the survey data in the Excel

Use the following approaches to analyze the survey data in the Excel file Insurance Survey. ■ Frequency distributions and histograms for the ratio variables (age, years employed, and satisfaction) ■ D...

Q: Use the COUNTIF function to construct frequency distributions for gender, preferred

Use the COUNTIF function to construct frequency distributions for gender, preferred genre, and influence, develop column charts to express the results visually, and compute the relative frequencies ba...

Q: One of PLE’s manufacturing facilities produces metal engine housings from sheet metal

One of PLE’s manufacturing facilities produces metal engine housings from sheet metal for both mowers and tractors. Production of each product consists of five steps: stamping, drill...

Q: The Excel file Auto Survey contains a sample of data about vehicles

The Excel file Auto Survey contains a sample of data about vehicles owned, whether they were purchased new or used, and other types of data. Use the appropriate statistical tools to analyze these data...

Q: The Excel file Employee Selection contains role of employees in an organization

The Excel file Employee Selection contains role of employees in an organization, along with other specifics—gender, salary, years of education, date of birth, and whether they are citizens of the coun...

Q: Use the Manufacturing Measurements Data Excel file to compute sample means,

Use the Manufacturing Measurements Data Excel file to compute sample means, assuming that each row in the data file represents a sample from the manufacturing process. Plot the sample means on a line...

Q: Airbnb is an online marketplace for arranging or offering lodging, primarily

Airbnb is an online marketplace for arranging or offering lodging, primarily homestays, or tourism experiences. Airbnb provides a platform for hosts to accommodate guests with short term lodging and t...

Q: A community health status survey obtained the following demographic information from the

A community health status survey obtained the following demographic information from the respondents: Compute the relative frequencies and cumulative relative frequencies of the age groups.

Q: Use the Histogram tool to construct frequency distributions and histograms for weekly

Use the Histogram tool to construct frequency distributions and histograms for weekly usage and waiting time in the Excel file Car Sharing Report. Do not group the data into bins.

Q: In the past week, an ice-cream kiosk sold 15

In the past week, an ice-cream kiosk sold 15 cups of chocolate flavor, 22 cups of vanilla, and 13 cups of strawberry. a. Estimate the probability of sale of each flavor for the following week. b. Defi...

Q: Sue and Dave always spend their evenings together, either cycling or

Sue and Dave always spend their evenings together, either cycling or playing computer games. On an evening with good weather, the probability that Sue prefers cycling is 0.7 and for Dave it is 0.4. Fi...

Q: A grocery shop is taking stock of its inventory. The shopkeeper

A grocery shop is taking stock of its inventory. The shopkeeper found that out of 120 tins with damaged labels, there are 50 tins of beans, 20 tins of sardines, 35 tins of processed meat, and the rest...

Q: A survey of shopping habits found the percentage of respondents that use

A survey of shopping habits found the percentage of respondents that use technology for shopping as shown in Figure 5.30. For example, 17.39% only use online coupons; 21.74% use online coupons and che...

Q: PLE has developed a prototype for a new snow blower for the

PLE has developed a prototype for a new snow blower for the consumer market. This can exploit the company’s expertise in small-gasoline-engine technology and also balance seasonal demand cycles in the...

Q: Based on the scenario in Problem 3, what is the probability

Based on the scenario in Problem 3, what is the probability of first selecting ball 1 and then selecting ball 3? Will it be different if the first ball is replaced in the glass jar? Explain the differ...

Q: The students at Skövde University, Sweden, have elected five candidates

The students at Skövde University, Sweden, have elected five candidates to represent them on the college management council. The committee summarized the age and gender of the members as...

Q: A consumer products company found that 44% of successful products also

A consumer products company found that 44% of successful products also received favorable results from test market research, whereas 11% had unfavorable results but nevertheless were successful. That...

Q: The number of children per family was determined and summarized in the

The number of children per family was determined and summarized in the following table. Find the expected number, variance, and standard deviation of the number of children per family.

Q: Padini Concept, a local retail store in Malaysia, recorded the

Padini Concept, a local retail store in Malaysia, recorded the number of shoes purchased by customers (1 pairs, 2 pairs and 3 pairs) based on the number of clothes purchased (1, 2, and 3) for a random...

Q: From a bag full of colored balls (red, blue,

From a bag full of colored balls (red, blue, green, and orange), a few are picked out and replaced. This is done 1,000 times and the number of times each colored ball is picked out is, blue balls = 30...

Q: A major application of analytics in marketing is determining customer retention.

A major application of analytics in marketing is determining customer retention. Suppose that the probability of a long-distance carrier’s customer leaving for another carrier from one month to the ne...

Q: During one 12-week period, a particular mutual fund outperformed

During one 12-week period, a particular mutual fund outperformed the S&P 500 index 37 out of 60 days. Find the probability that it would perform as well or better again.

Q: A glass jar contains 10 balls with labels of numbers 1 to

A glass jar contains 10 balls with labels of numbers 1 to 10. Two balls are randomly selected from the glass jar without replacement. a. Determine the number of combinations possible in the sample spa...

Q: A popular resort hotel has 300 rooms and is usually fully booked

A popular resort hotel has 300 rooms and is usually fully booked. About 7% of the time a reservation is canceled before the 6:00 p.m. deadline with no penalty. What is the probability that at least 28...

Q: The background for this case was introduced in Chapter 2. This

The background for this case was introduced in Chapter 2. This is a continuation of the case in Chapter 4. For this part of the case, compute confidence intervals for means and proportions and analyze...

Q: A transport company is inspecting 80 trucks it owns. The inspection

A transport company is inspecting 80 trucks it owns. The inspection determines that the probability of trucks failing the inspection is 0.25. Find the probability that not more than 10 trucks failed t...

Q: A life insurance consultant sells three life insurance policies on an average

A life insurance consultant sells three life insurance policies on an average per week for which she receives a fee. Use Poisson’s distribution to calculate the probability that in a given week she wi...

Q: The number and frequency of hurricanes over a certain ocean, annually

The number and frequency of hurricanes over a certain ocean, annually from 1945 through 2020, is shown here. For instance, this means that no hurricanes occurred during 6 of these years, only one hurr...

Q: The time required to play a game of Battleship™ is uniformly

The time required to play a game of Battleship™ is uniformly distributed between 20 and 60 minutes. a. Find the expected value and variance of the time to complete the game. b. What is the probability...

Q: A student is drawing a rectangle, which has a perimeter of

A student is drawing a rectangle, which has a perimeter of 20 cm. He wants the length, x cm, of one side of this rectangle to be uniformly distributed between 1 cm and 7 cm. Find the probability that...

Q: In determining bike mileage ratings, it was found that the mpg

In determining bike mileage ratings, it was found that the mpg (X) for a certain model is normally distributed, with a mean of 34 mpg and a standard deviation of 1.9 mpg. Find the following: a. P(X <...

Q: The distribution of SAT scores in math for an incoming class of

The distribution of SAT scores in math for an incoming class of business students has a mean of 610 and standard deviation of 20. Assume that the scores are normally distributed. a. Find the probabili...

Q: A popular soft drink is sold in 2-liter (2

A popular soft drink is sold in 2-liter (2,000-milliliter) bottles. Because of variation in the filling process, bottles have a mean of 2,000 milliliters and a standard deviation of 18, normally distr...

Q: A box contains marbles of four different colors: red, green

A box contains marbles of four different colors: red, green, blue, and yellow. Three marbles are randomly chosen from the box. a. List all possible outcomes in the sample space. b. What is the probabi...

Q: A fisherman found that the average length of cherry hybrid salmon is

A fisherman found that the average length of cherry hybrid salmon is about 20 inches with a standard deviation of 2 inches. By assuming the cherry salmon’s length is normally distributed, find the pro...

Q: In reviewing your previous reports, several questions came to Elizabeth Burke’s

In reviewing your previous reports, several questions came to Elizabeth Burke’s mind. Use point and interval estimates to help answer these questions. 1. What proportion of customers rate the company...

Q: According to historical data, a European musician finds that customers who

According to historical data, a European musician finds that customers who download music from a popular Web service spend approximately €24 per month, with a standard deviation of €4. Find the probab...

Q: According to WHO, around 1.35 million people die each

According to WHO, around 1.35 million people die each year due to road accidents. Suppose that on a specific highway, an average of four accidents occur within every hour. Find the probability that th...

Q: The actual delivery time from a pizza delivery company is exponentially distributed

The actual delivery time from a pizza delivery company is exponentially distributed with a mean of 28 minutes. a. What is the probability that the delivery time will exceed 31 minutes? b. What proport...

Q: Apply the chi-square goodness of fit test to the data

Apply the chi-square goodness of fit test to the data in the Airport Service Times Excel file to determine if a normal distribution models the data. Use bins of width 100. Note that for a normal distr...

Q: Apply the chi-square goodness of fit test to the data

Apply the chi-square goodness of fit test to the data in the Airport Service Times Excel file to determine if an exponential distribution models the data. Use bins of width 100. Note that for an expon...

Q: Compute the daily change of the closing price for the data in

Compute the daily change of the closing price for the data in the Excel file S&P 500. Compute descriptive statistics, a frequency distribution, and histogram for the closing prices (using a bin width...

Q: The latest nationwide political poll in a particular country indicates that the

The latest nationwide political poll in a particular country indicates that the probability for the candidate to be a republican is 0.55, a communist is 0.30, and a supporter of the patriots of that c...

Q: Refer to the ball scenario described in Problem 3. a

Refer to the ball scenario described in Problem 3. a. Let A be the event with the sum of the selected two balls is an odd number. Find P(A) and P(Ac). b. What is the probability that the sum of the tw...

Q: Answer the following by referring to the scenario described in Problem 4

Answer the following by referring to the scenario described in Problem 4. a. Let A be the event “without blue marble.” Find P(A). b. Let B be the event “first marble selected is green.” Find P(B). c....

Q: Students in the new MBA class at a state university have the

Students in the new MBA class at a state university have the following specialization profile: Finance—83 Marketing—36 Operations and Supply Chain Management—72 Information Systems—59 Find the probab...

Q: The background for this case was introduced in Chapter 2. This

The background for this case was introduced in Chapter 2. This is a continuation of the case in Chapter 6. For this part of the case, propose and test some meaningful hypotheses that will help Ms. Dro...

Q: Your college or university wishes to obtain reliable information about student perceptions

Your college or university wishes to obtain reliable information about student perceptions of administrative communication. Describe how to design a sampling plan for this situation based on your know...

Q: Suppose that the mean monthly expenditure of the region identified in Problem

Suppose that the mean monthly expenditure of the region identified in Problem 8 is $15,500. What is the probability that the random sample of 380 residents will have a mean monthly expenditure of more...

Q: In determining automobile mileage ratings, it was found that the mpg

In determining automobile mileage ratings, it was found that the mpg in the city for a certain model is normally distributed, with a mean of 41 mpg and a standard deviation of 1.8 mpg. Suppose that th...

Q: Each can of a certain brand of sweet corn contains an average

Each can of a certain brand of sweet corn contains an average of 375 corn kernels with a standard deviation of 8 in each can. Yesterday, Winnie went to a local store and purchased four cans of corn. a...

Q: A random sample of 100 teenagers was surveyed, and the mean

A random sample of 100 teenagers was surveyed, and the mean number of songs that they had downloaded from the iTunes store in the past month was 9.4 with the results considered accurate being within 1...

Q: A survey of 34 freshmen found that they get an average of

A survey of 34 freshmen found that they get an average of 6.26 hours of sleep each night. A 90% confidence interval had a margin of error of 0.509. a. What are the lower and upper limits of the confid...

Q: A sample of 40 individuals at a shopping mall found that the

A sample of 40 individuals at a shopping mall found that the mean number of visits to a restaurant per week was 2.88 with a standard deviation of 1.59. Find a 99% confidence interval for the mean numb...

Q: A survey of 23 individuals found that they spent an average of

A survey of 23 individuals found that they spent an average of $39.48 on headphones to use for exercising. The margin of error for a 95% confidence interval was found to be 21.2. a. What are the lower...

Q: For the data in the Excel file Grade Point Averages, find

For the data in the Excel file Grade Point Averages, find 90%, 95%, and 99% confidence intervals for the mean GPA. Compute the confidence intervals using the appropriate formulas and verify your resul...

Q: The Excel file Diabetes Check contains the records of patients with diabetes

The Excel file Diabetes Check contains the records of patients with diabetes who have received treatment at a local hospital. Number each row in the dataset and help the hospital to select a simple ra...

Q: Elizabeth Burke has identified some additional questions she would like you to

Elizabeth Burke has identified some additional questions she would like you to answer using the Performance Lawn Equipment Database. 1. Are there significant differences in ratings of specific product...

Q: For the data in the Excel file Debt and Retirement Savings,

For the data in the Excel file Debt and Retirement Savings, find 95% confidence intervals for the mean income, long-term debt, and retirement savings. Use the appropriate formulas and Excel functions....

Q: A study was conducted to examine the time spent on studying by

A study was conducted to examine the time spent on studying by students at a university and whether they pass or fail a course. It found that to pass or fail a course the standard deviation were 5 hou...

Q: Using the data in the Excel file Accountants, find and interpret

Using the data in the Excel file Accountants, find and interpret 90% confidence intervals for the following: a. mean years of service b. proportion of employees who have a graduate degree Use the app...

Q: According to Moovit Insights website, the average amount of time people

According to Moovit Insights website, the average amount of time people in Singapore spend commuting to and from work, on a weekday, using public transport is 84 minutes. Recent studies have shown tha...

Q: A survey of 50 young professionals found that they spent an average

A survey of 50 young professionals found that they spent an average of $20.21 when dining out, with a standard deviation of $13.88. Can you conclude statistically that the population mean is greater t...

Q: A survey of 270 individuals found that one-sixth of them

A survey of 270 individuals found that one-sixth of them use their cell phones primarily for email. Can you conclude statistically that the population proportion who use cell phones primarily for emai...

Q: The Excel file Professionality shows select lecturers at a university and their

The Excel file Professionality shows select lecturers at a university and their related information such as gender, status of current position, number of years in current position, highest degree, num...

Q: Due to rapid developments in technology, the number of laptops per

Due to rapid developments in technology, the number of laptops per household has also increased. A study was conducted for two housing areas to determine the average number and proportion of laptops p...

Q: For the data in the Excel file Education and Income, find

For the data in the Excel file Education and Income, find 95% confidence intervals for the mean annual income of males and the mean annual income of females. Can you conclude that the mean income of o...

Q: For the data in the Excel file Debt and Retirement Savings,

For the data in the Excel file Debt and Retirement Savings, find 95% confidence intervals for the mean income, long-term debt, and retirement savings for individuals who are single and individuals who...

Q: In reviewing the data in the Performance Lawn Equipment Database, Elizabeth

In reviewing the data in the Performance Lawn Equipment Database, Elizabeth Burke noticed that defects received from suppliers have decreased (worksheet Defects After Delivery). Upon investigation, sh...

Q: A survey of 23 patients at a hospital found 95% confidence

A survey of 23 patients at a hospital found 95% confidence intervals for the following: Construct a stock chart-based visualization of these confidence intervals. What conclusions can you draw from th...

Q: The Excel file High Blood Pressure records the results of 30 individuals

The Excel file High Blood Pressure records the results of 30 individuals who were tested for hypertension. Use the Excel Sampling tool to obtain a random sample of 5 individuals and compute point esti...

Q: Trade associations, such as the United Dairy Industry Association, frequently

Trade associations, such as the United Dairy Industry Association, frequently conduct surveys to identify characteristics of their membership. If this organization conducted a survey to estimate the a...

Q: If a manufacturer conducted a survey among randomly selected target market households

If a manufacturer conducted a survey among randomly selected target market households and wanted to be 99% confident that the difference between the sample estimate and the actual market share for its...

Q: A gym instructor records the weights of a random sample of 31

A gym instructor records the weights of a random sample of 31 male high school students. The mean weight was found to be 140 pounds and the standard deviation of this population is 20 pounds. How larg...

Q: After launching a new range of health drinks, a local fitness

After launching a new range of health drinks, a local fitness company conducted a survey to understand how the products were being received. From a random sample of 500 customers, who were asked to pa...

Q: Using the Excel file Diabetes Check, draw five random samples by

Using the Excel file Diabetes Check, draw five random samples by repeating the sampling experiment for sample sizes 10, 15, and 20. For each sample sizes, find the stabilized glucose point estimates f...

Q: Based on extensive data from a national high school educational testing program

Based on extensive data from a national high school educational testing program, the standard deviation of national test scores for mathematics was found to be 118 points. If a sample of 324 students...

Q: In one region in your country, suppose that the standard deviation

In one region in your country, suppose that the standard deviation of monthly expenditure of the residents is about $7,000. In a random sample of 380 residents, what is the standard error of the mean...

Q: Suppose that the mean score for the mathematics test cited in Problem

Suppose that the mean score for the mathematics test cited in Problem 7 is 607. What is the probability that a random sample of 324 students will have a mean score of more than 619? Less than 588?

Q: An important part of planning manufacturing capacity is having a good forecast

An important part of planning manufacturing capacity is having a good forecast of sales. Elizabeth Burke is interested in forecasting sales of mowers and tractors in each marketing region as well as i...

Q: When President Donald Trump took office, he believed that the reason

When President Donald Trump took office, he believed that the reason he did not win the popular vote was because 3 to 5 million people voted illegally. Explain how hypothesis testing might be used in...

Q: A marine biologist wants to use a parrotfish for research purposes as

A marine biologist wants to use a parrotfish for research purposes as she believes that the variability of weights among parrotfish is small. From a random sample of 50 parrotfish, she found that thei...

Q: A pharmacist believes that in manufacturing a pill or tablet medicine,

A pharmacist believes that in manufacturing a pill or tablet medicine, the need for an active ingredient in each pill is less than 14 milligrams. She selects a random sample of 15 pills and determines...

Q: Using the data in the Excel file Consumer Transportation Survey, test

Using the data in the Excel file Consumer Transportation Survey, test the following null hypotheses: a. Individuals spend at least eight hours per week in their vehicles. b. Individuals drive an avera...

Q: A gum manufacturer claims that on average the flavor of an entire

A gum manufacturer claims that on average the flavor of an entire packet of its gum would last for more than 39 minutes. A quality controller selects a random sample of 55 packets of gum. She finds th...

Q: A diet program claims that the average amount of water that a

A diet program claims that the average amount of water that a person on a diet should drink each day to lose weight is 4 liters. A random sample of 13 people enrolled in the diet program found that th...

Q: A computer repair firm believes that its average repair time is less

A computer repair firm believes that its average repair time is less than two weeks. Using the data in the Excel file Computer Fix Times, determine if the company can continue to support this claim.

Q: A survey on female health stated that the standard body fat percentage

A survey on female health stated that the standard body fat percentage of a woman of the average age of 25 years with an average weight of 140 pounds and an average height of 64 inches is 16%. The Exc...

Q: A gym trainer in Cologne, Germany, believes that the average

A gym trainer in Cologne, Germany, believes that the average time spent exercising each day by the city is greater than 1.5 hours. Formulate an appropriate one sample test of hypothesis to test this b...

Q: An industry trade publication stated that the average profit per customer for

An industry trade publication stated that the average profit per customer for this industry was greater than $4,500. The Excel file Sales Data provides data on a sample of customers. Using a test of h...

Q: Jamie Drout is interested in perceptions of gender stereotypes within beauty product

Jamie Drout is interested in perceptions of gender stereotypes within beauty product advertising, which includes soap, deodorant, shampoo, conditioner, lotion, perfume, cologne, makeup, chemical hair...

Q: For each of the following scenarios, state whether descriptive, predictive

For each of the following scenarios, state whether descriptive, predictive, or prescriptive analytics tools would most likely be used. a. An insurance firm wants to analyze fraudulent claims to predic...

Q: A financial advisor believes that the proportion of investors who are risk

A financial advisor believes that the proportion of investors who are risk-averse (that is, try to avoid risk in their investment decisions) is at least 0.6. A survey of 31 investors found that 19 of...

Q: Suppose that a previous record of a blood donation campaign conducted in

Suppose that a previous record of a blood donation campaign conducted in the city of London indicates that the probability of a donor having blood type O is 0.6. Of a sample of 120 donors who have com...

Q: The Excel file Room Inspection provides data for 100 room inspections at

The Excel file Room Inspection provides data for 100 room inspections at each of 25 hotels in a major chain. Management would like the proportion of nonconforming rooms to be less than 2%. Formulate a...

Q: A two-sample test for means was conducted to test whether

A two-sample test for means was conducted to test whether the mean number of movies watched each month differed between males and females. The Excel Data Analysis tool results are shown below. a. Expl...

Q: A two-sample test for means was conducted to determine if

A two-sample test for means was conducted to determine if the completion time for continuing education programs for nurses differed when costs are paid by employers (Yes) versus when individuals paid...

Q: Using the Excel file YouTube Hours, determine if the mean number

Using the Excel file YouTube Hours, determine if the mean number of hours spent online per week is the same for males as it is for females.

Q: A research group in Sweden estimated that almost 1.5 million

A research group in Sweden estimated that almost 1.5 million people in Sweden have used Netflix from September to December 2018. Formulate an appropriate one-sample test of hypothesis to test this.

Q: The Excel file Fortune100 Accountants provides the results of a survey of

The Excel file Fortune100 Accountants provides the results of a survey of 35 employees in a tax division of a Fortune 100 company. a. Is there sufficient evidence at the 0.01 level of significance th...

Q: For the data in the Excel file Coffee Shop Preferences, conduct

For the data in the Excel file Coffee Shop Preferences, conduct a hypothesis test to determine if price and taste ratings are the same for large/chain stores versus small/independent coffee shops.

Q: For the data in the Excel file Netflix Views Survey, conduct

For the data in the Excel file Netflix Views Survey, conduct a hypothesis test to determine if married individuals watch less Netflix than single individuals.

Q: A firm installs 1,500 air conditioners that need to be

A firm installs 1,500 air conditioners that need to be checked every six months. The firm can hire a team from its logistics department at a fixed cost of €6,000. This team will check each unit for €1...

Q: Determine if there is evidence to conclude that rain fall in area

Determine if there is evidence to conclude that rain fall in area A is significantly more than that of area B using the data in the Excel file Rainfall.

Q: Looking at the data and information in the Excel file Car Sharing

Looking at the data and information in the Excel file Car Sharing Survey, state some examples of interesting hypothesis tests by proposing null and alternative hypotheses.

Q: For the Excel file Job Satisfaction, use ANOVA to determine if

For the Excel file Job Satisfaction, use ANOVA to determine if the mean overall job satisfaction ratings differ by department.

Q: For the data in the Excel file Helpdesk Survey, determine if

For the data in the Excel file Helpdesk Survey, determine if the mean overall satisfaction ratings differ by the ratings given for response time.

Q: Using the data in the Excel file Broadband Service Providers, apply

Using the data in the Excel file Broadband Service Providers, apply ANOVA to determine if the mean response for value for the pound is the same for different types of broadband service providers in th...

Q: For the data in the Excel file Freshman College Data,

For the data in the Excel file Freshman College Data, a. use ANOVA to determine whether significant differences exist in the mean retention rate for the different colleges over the four-year period. b...

Q: The cross-tabulation data given below represent the number of males

The cross-tabulation data given below represent the number of males and females in a work group who feel overstressed and those who don’t. a. Write the hypotheses for the chi-square...

Q: The cross-tabulation data given below represent the number of passed

The cross-tabulation data given below represent the number of passed and failed results of male and female students at a university for the last semester. a. Write the hypotheses for the chi-square te...

Q: The following cross-tabulation shows the number of people who rated

The following cross-tabulation shows the number of people who rated a customer service representative as friendly and polite based on whether the representative greeted them first. a. Write the hypoth...

Q: Looking at the data and information in the Excel file Retail Survey

Looking at the data and information in the Excel file Retail Survey, state some examples of interesting hypothesis tests by proposing null and alternative hypotheses.

Q: Use the model to predict the total sales for weeks 2 through

Use the model to predict the total sales for weeks 2 through 16, and compare the results to the observed sales. Does the accuracy of the model seem to be different when coupons are used or not? When a...

Q: Conduct the chi-square test for independence using the aggregated results

Conduct the chi-square test for independence using the aggregated results using a level of significance of 0.05.

Q: For the following cross-tabulation data, which represent a count

For the following cross-tabulation data, which represent a count of the type of books that individuals prefer, verify that the assumptions of the chi-square test are not met, and aggregate the data in...

Q: A manufacturer of automobiles is bringing out a new model. To

A manufacturer of automobiles is bringing out a new model. To create its advertising campaign, the manufacturer wants to determine whether the model’s appeal will be dependent on a p...

Q: Four call service representatives were monitored over a period of three months

Four call service representatives were monitored over a period of three months. After each call, every customer was asked whether they were satisfied with the service by answering “Y...

Q: Conduct a chi-square test to determine if a normal distribution

Conduct a chi-square test to determine if a normal distribution can reasonably model the data in the Excel file Airport Service Times.

Q: Conduct a chi-square test to determine if a normal distribution

Conduct a chi-square test to determine if a normal distribution can reasonably model the expense data in the Excel file Travel Expenses.

Q: Conduct a chi-square test to determine if a normal distribution

Conduct a chi-square test to determine if a normal distribution can reasonably model the sum of the midterm and final exam grades in the Excel file Student Grades.

Q: Looking at the data and information in the Excel file TV Viewing

Looking at the data and information in the Excel file TV Viewing Survey, state some examples of interesting hypothesis tests by proposing null and alternative hypotheses.

Q: A pharmaceutical company in Australia is testing a medical drug that intends

A pharmaceutical company in Australia is testing a medical drug that intends to increase heart rate. A sample of 124 tests yielded a mean increase of 1.4 beats per minute, with a population standard d...

Q: An analyst at a business school in France is assessing students’ performance

An analyst at a business school in France is assessing students’ performance. Historical records of applicants suggest that the mean score obtained by students attending the school is 350. The busines...

Q: The yearly government tax revenue (in $ millions) depends on

The yearly government tax revenue (in $ millions) depends on customer income, business profits, and capital gains defined as tax = -2.556 + 3.799 *income + 1.583 * profit + 0.739 * capital. a. Interpr...

Q: According to a magazine, people read an average of more than

According to a magazine, people read an average of more than three books in a month. A survey of 20 random individuals found that the mean number of books they read was 2.9 with a standard deviation o...

Q: Using the data in the Excel file Kidney, apply the Excel

Using the data in the Excel file Kidney, apply the Excel Regression tool using kidney frailty rates and age of a person as the variables. Interpret all key regression results, hypothesis tests, and co...

Q: The Excel file Horsepower versus Gasoline provides data on the amount of

The Excel file Horsepower versus Gasoline provides data on the amount of gasoline used per 100 miles by different brands of cars along with their horsepower. a. Construct a scatter diagram for gasolin...

Q: Using the data in the Excel file Student Grades, apply the

Using the data in the Excel file Student Grades, apply the Excel Regression tool using the midterm grade as the independent variable and the final exam grade as the dependent variable. Interpret all k...

Q: Using the Excel file Weddings, apply the Regression tool using the

Using the Excel file Weddings, apply the Regression tool using the wedding cost as the dependent variable and attendance as the independent variable. a. What is the regression model? b. Interpret all...

Q: Using the Excel file Weddings, apply the Excel Regression tool using

Using the Excel file Weddings, apply the Excel Regression tool using the wedding cost as the dependent variable and the couple’s income as the independent variable, only for those weddings paid for by...

Q: Use the results for Problem 10 (Demographics) to analyze the

Use the results for Problem 10 (Demographics) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determin...

Q: Use the results (Horsepower versus Gasoline) to analyze the residuals

Use the results (Horsepower versus Gasoline) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine...

Q: Use the results (Student Grades) to analyze the residuals to

Use the results (Student Grades) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any poss...

Q: Use the results (Weddings) to analyze the residuals to determine

Use the results (Weddings) to analyze the residuals to determine if the assumptions underlying the regression analysis are valid. In addition, use the standard residuals to determine if any possible o...

Q: In a toy manufacturing company, the manufacturer needs to pay rent

In a toy manufacturing company, the manufacturer needs to pay rent (p) each month and monthly electricity (q). To produce each toy, the company incurs costs for plastic (r) and for cloth (s). The vari...

Q: A consumer products company has collected some data relating to the advertising

A consumer products company has collected some data relating to the advertising costs and sales of one of its products: What type of model would best represent the data? Use the Trendline tool to find...

Q: The Excel file World Tour Sales provides data on sales (£) and

The Excel file World Tour Sales provides data on sales (£) and the number of radio, TV, and newspaper ads promoting the world tour for a group of countries. Develop simple linear regression models for...

Q: Using the data in the Excel file Home Market Value, develop

Using the data in the Excel file Home Market Value, develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. State the model and...

Q: Use the data in the Excel file Canned Food to find a

Use the data in the Excel file Canned Food to find a multiple regression model to predict the total sales as a function of all the other given variables. State the model and explain R2, Significance F...

Q: Use the data in the Excel file Neighborhoods to find a multiple

Use the data in the Excel file Neighborhoods to find a multiple regression model to predict the total sales as a function of all the other given variables. State the model and explain R2, Significance...

Q: Using the data in the Excel file Credit Card Spending, develop

Using the data in the Excel file Credit Card Spending, develop a multiple linear regression model for estimating the average credit card expenditure as a function of both the income and family size. P...

Q: Use the data in the Excel file EU Cost of Living Adjustments

Use the data in the Excel file EU Cost of Living Adjustments to find the best multiple regression model to predict the salary as a function of the adjusted cost of living rates. What would the compara...

Q: Use the data in the Excel file Job Satisfaction to find the

Use the data in the Excel file Job Satisfaction to find the best multiple regression model to predict the overall satisfaction as a function of the other variables. What managerial implications does y...

Q: The Excel file Breakfast Foods provides a variety of nutritional information about

The Excel file Breakfast Foods provides a variety of nutritional information about 67 breakfast food items in supermarkets in different parts of the world. Use regression analysis to find the best mod...

Q: The Excel file Credit Approval Decisions provides information on credit history for

The Excel file Credit Approval Decisions provides information on credit history for a sample of banking customers. Use regression analysis to identify the best model for predicting the credit score as...

Q: An insurance company is estimating the risk model based on customer age

An insurance company is estimating the risk model based on customer age is define as R = aebx where a is a fixed constant and b is a constant that depends on the customer age. They categorize the age...

Q: Each worksheet in the Excel file LineFit Data contains a set of

Each worksheet in the Excel file LineFit Data contains a set of data that describes a functional relationship between the dependent variable y and the independent variable x. Construct a line chart of...

Q: The Excel file Women Height Data provides information on women’s height,

The Excel file Women Height Data provides information on women’s height, their mother’s height, their father’s height, amount of protein intake (per day), and the hours of exercise (per day) for a sel...

Q: A researcher is analyzing the body fat percentage based on the measurements

A researcher is analyzing the body fat percentage based on the measurements of triceps, thigh, and mid-arm of a person (in inches). The data is recorded in the Excel file Body Fat Percentage. a. Use t...

Q: A leading car manufacturer tracks the data of its used cars for

A leading car manufacturer tracks the data of its used cars for resale. The Excel file Car Sales contains information on the selling price of the car, fuel type (diesel or petrol), horsepower (HP), an...

Q: For the Car Sales data described in Problem 35, develop a

For the Car Sales data described in Problem 35, develop a regression model for selling price as a function of horsepower and manufacture year, incorporating an interaction term. What would be the pre...

Q: For the Excel file Job Satisfaction, develop a regression model for

For the Excel file Job Satisfaction, develop a regression model for overall satisfaction as a function of years of service and department that has the largest R2. Which department, if any, has the hig...

Q: A product manufacturer wishes to determine the relationship between the shelf space

A product manufacturer wishes to determine the relationship between the shelf space of the product and its sales. Past data indicates the following sales and shelf space in its stores: Using these dat...

Q: Using the data in the Excel file Kidney, determine the relationship

Using the data in the Excel file Kidney, determine the relationship between frailty rates in people with chronic kidney disease and the age of a person by constructing a scatter chart for the data. Fi...

Q: Use the data in the Excel file MBA Motivation and Salary Expectations

Use the data in the Excel file MBA Motivation and Salary Expectations to determine how well a linear function models the relationship between pre- and post-MBA salaries. Compare it to a third-order po...

Q: Using the results of fitting the Home Market Value regression line in

Using the results of fitting the Home Market Value regression line in Example 8.4, compute the errors associated with each observation using formula) and construct a frequency distribution and histogr...

Q: Enhance the Sales Transactions database file to perform a database query that

Enhance the Sales Transactions database file to perform a database query that finds the transaction code and amount associated with any customer ID input. Apply your results to customer ID 10029.

Q: The managing director of a consulting group has the following monthly data

The managing director of a consulting group has the following monthly data on total overhead costs and professional labor hours to bill to clients: a. Develop a simple linear regression model between...

Q: For the data in the Excel file Airport Passengers, do the

For the data in the Excel file Airport Passengers, do the following: a. Develop a spreadsheet for forecasting the number of airport passengers using simple exponential smoothing with smoothing constan...

Q: For the coal production example using double exponential smoothing, experiment with

For the coal production example using double exponential smoothing, experiment with the spreadsheet model to find the best values of  and  that minimize MAD.

Q: Consider the prices for the Stock Exchange in the Excel file Stock

Consider the prices for the Stock Exchange in the Excel file Stock Prices. Use simple linear regression to forecast the data. What would be the forecasts for the next three days?

Q: Consider the data in the Excel file Internet Users. Use simple

Consider the data in the Excel file Internet Users. Use simple linear regression to forecast the data. What would be the forecast for the next three years?

Q: Develop a multiple linear regression model with categorical variables that incorporate seasonality

Develop a multiple linear regression model with categorical variables that incorporate seasonality for forecasting the deaths caused by accidents in the United States. Use the data for years 1976 and...

Q: Develop a multiple regression model with categorical variables that incorporate seasonality for

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting sales using the last three years of data in the Excel file Auto Sales.

Q: Develop a multiple regression model with categorical variables that incorporate seasonality for

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting 2010 housing starts using the 2008 and 2009 data in the Excel file Housing Starts.

Q: Develop a multiple regression model with categorical variables that incorporate seasonality for

Develop a multiple regression model with categorical variables that incorporate seasonality for forecasting for the data in the Excel file Tourists Arrival.

Q: Experiment with the Holt-Winters Additive Model for Seasonality spreadsheet to

Experiment with the Holt-Winters Additive Model for Seasonality spreadsheet to find the best combination of  and  to minimize MAD.

Q: Enhance the Yield Rates database file to perform a database query that

Enhance the Yield Rates database file to perform a database query that finds the rate associated with any date and term. (This is a challenging question because you will not be able to use the term he...

Q: Modify the Excel file Holt-Winters Additive Model for Seasonality to

Modify the Excel file Holt-Winters Additive Model for Seasonality to implement the Holt-Winters multiplicative seasonality model with no trend.

Q: Experiment with the Holt-Winters Additive Model for Seasonality and Trend

Experiment with the Holt-Winters Additive Model for Seasonality and Trend spread sheet model to find the best combination of , , and  to minimize MSE.

Q: Modify the Excel file Holt-Winters Additive Model for Seasonality and

Modify the Excel file Holt-Winters Additive Model for Seasonality and Trend for the New Car Sales data to implement the Holt-Winters multiplicative seasonality model with trend. Try to find the best c...

Q: The Excel file CD Interest Rates provides annual average interest rates on

The Excel file CD Interest Rates provides annual average interest rates on six-month certificate of deposits. Compare the Holt-Winters additive and multiplicative models using  = 0.7,  = 0.3,  = 0....

Q: Using Table 9.1, Determine the most appropriate forecasting technique

Using Table 9.1, Determine the most appropriate forecasting technique for the data in the Excel file DJIA December Close and implement the model. Data from Table 9.1:

Q: Using table 9.1, Determine the most appropriate forecasting technique

Using table 9.1, Determine the most appropriate forecasting technique for the data in the Excel file Mortgage Rates and implement the model. Data from Table 9.1:

Q: Using table 9.1, Determine the most appropriate forecasting technique

Using table 9.1, Determine the most appropriate forecasting technique for the data in the Excel file Prime Rate and implement the model. Data from Table 9.1:

Q: Using Table 9.1, determine the most appropriate forecasting technique

Using Table 9.1, determine the most appropriate forecasting technique for the data in the Excel file Treasury Yield Rates and implement the model. Data from Table 9.1:

Q: Using Excel’s Moving Average tool for the data in the Excel file

Using Excel’s Moving Average tool for the data in the Excel file Occupancy, identify the moving trend for each of the hotels, motels, backpacker hostels, and holiday parks.

Q: For each of the time series in the following Excel files,

For each of the time series in the following Excel files, construct a line chart of the data and identify the characteristics of the time series (that is, random, stationary, trend, seasonal, or cycli...

Q: For this exercise, use the Wikipedia database. Use MATCH and

For this exercise, use the Wikipedia database. Use MATCH and/or INDEX functions to find the following: a. The row numbers corresponding to the first and last instance of name Affaire_Réveillon in col...

Q: Use http://www.fao.org/faostat/en

Use http://www.fao.org/faostat/en/#data to extract an annual dataset for any topic of your interest that would aid in constructing a statistical forecasting model analysis. Download the relevant datas...

Q: For the data in the Excel file Airport Passengers, do the

For the data in the Excel file Airport Passengers, do the following: a. Develop a spreadsheet for forecasting the number of airport passengers using a simple three-period moving average. b. Compute MA...

Q: The Excel file New Registered Users provides data on new registrations to

The Excel file New Registered Users provides data on new registrations to an App on a monthly basis for four years. Compare the 3- and 12-month moving average forecasts using the MAD criterion. Explai...

Q: The Excel file Closing Stock Prices provides data for four stocks and

The Excel file Closing Stock Prices provides data for four stocks and the Dow Jones Industrial Average over a one-month period. a. Develop a spreadsheet for forecasting each of the stock prices and th...

Q: The Excel file Stock Prices provides data for four stocks and the

The Excel file Stock Prices provides data for four stocks and the stock exchange average over a 12 day period. a. Use Excel’s Data Analysis Exponential Smoothing tool to forecast each of the stock pri...

Q: Compute the Euclidean distance between the following set of points:

Compute the Euclidean distance between the following set of points: a. (1.06, 9.2) and (0.89, 10.3) b. (1.6, 0.628, 9.077) and (2.2, 1.555, 5.088)

Q: Extract the records and code the non-numerical data Company in

Extract the records and code the non-numerical data Company in the Excel file Train Journey Decisions. Apply the discriminant analysis to classify the occupied seats for the train passengers in the Re...

Q: The Excel file Auto Options provides data on options ordered together for

The Excel file Auto Options provides data on options ordered together for a particular automobile model. By examining the correlation matrix, suggest some Associations.

Q: The Excel file Automobile Options 2 provides data on options ordered together

The Excel file Automobile Options 2 provides data on options ordered together for a particular model of automobile. Consider the following rules: Rule 1: If Fastest Engine, then Traction Control. Rule...

Q: Identify the leading and lagging measures for the variables provided in the

Identify the leading and lagging measures for the variables provided in the Excel file Eraser. Find the correlation matrix and propose a cause-and-effect model using the strongest correlations.

Q: Use INDEX and MATCH functions to fill in a table that extracts

Use INDEX and MATCH functions to fill in a table that extracts the amounts shipped between each pair of cities in the Excel file General Appliance Corporation, which shows the solution to an optimizat...

Q: For the Excel file Pharmaceuticals, normalize each column of the numerical

For the Excel file Pharmaceuticals, normalize each column of the numerical data (i.e., compute a Z-score for each of the values) and then compute the Euclidean distances between the following pharmace...

Q: For the three clusters identified in Table 10.3, find

For the three clusters identified in Table 10.3, find the average and standard deviations of each numerical variable for the schools in each cluster and compare them with the average and standard devi...

Q: For the Excel file Total Population, find a normalized distance matrix

For the Excel file Total Population, find a normalized distance matrix between Arkansas, Delaware, South Carolina, and South Dakota states. Apply single linkage clustering to these states and draw a d...

Q: Using only Credit Score, Years of Credit History, Revolving Balance

Using only Credit Score, Years of Credit History, Revolving Balance, and Revolving Utilization, apply single linkage cluster analysis to the first six records in the Excel file Credit Approval Decisio...

Q: Apply single linkage cluster analysis to the first five records in the

Apply single linkage cluster analysis to the first five records in the Excel file Sales Data, using the variables Percent Gross Profit, Industry Code, and Competitive Rating, and draw a dendogram illu...

Q: Using the approach described, classify first record in the worksheet Records

Using the approach described, classify first record in the worksheet Records to Classify in the Excel file Train Journey Decisions by using the k-NN algorithm for k = 1 to 5.

Q: Use discriminant analysis to classify the new records in the Excel file

Use discriminant analysis to classify the new records in the Excel file Train Journey Decisions using only hourly passenger and adult rate as input variables.

Q: A manufacturer of kitchen appliances is preparing to set the price on

A manufacturer of kitchen appliances is preparing to set the price on a new blender. Demand is thought to depend on the price and is represented by the model D = 2,900 - 2P The accounting department e...

Q: Construct an influence diagram for the portfolio allocation model in Example 11

Construct an influence diagram for the portfolio allocation model in Example 11.15. Data from Example 11.15:

Q: Economists believe that housing starts depend on interest rates and demographic factors

Economists believe that housing starts depend on interest rates and demographic factors such as population size, family income, and the age of the home buying population. In addition, interest rates d...

Q: The People’s Choice Bank is a small community bank that has three

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, Delhi, and Anderson Hills. The Excel file People’s Choice Bank is a database of major account transaction...

Q: In the Factvalue database, you need to find the country with

In the Factvalue database, you need to find the country with a birth rate of 29.43 and identify the country’s death rate. Write functions for a left table lookup to answer these queries.

Q: The monthly demand for a digital camera is sensitive to price:

The monthly demand for a digital camera is sensitive to price: Find the most appropriate trendline to explain the relationship between demand and price, and develop a model for the monthly revenue.

Q: Develop a spreadsheet for calculating the total revenue for the Intel scenario

Develop a spreadsheet for calculating the total revenue for the Intel scenario. Design it such that the price-demand function parameters are easy to change.

Q: A famous fashion boutique in Shanghai, China, is planning its

A famous fashion boutique in Shanghai, China, is planning its pricing for a dress that can be worn on Christmas day as well as the Chinese New Year. The product will be sold for ¥100 in the boutique a...

Q: Develop a spreadsheet model to determine how much a person or a

Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house.11 Lender guidelines suggest that the allowable monthly housing expenditure should be no more than...

Q: Intel, the largest semiconductor manufacturing company in the world, sells

Intel, the largest semiconductor manufacturing company in the world, sells two major types of computer chips, type A and type B. The sales of these two chips are dependent of each other (in economics,...

Q: A bi-monthly Sunday bazaar is held at a local maretplace

A bi-monthly Sunday bazaar is held at a local maretplace in London, England. The expected crowd is 4,500. The average expenditure estimate is £25 per person. Entry coupons sell for £10 each, and the b...

Q: A stockbroker calls on potential clients from referrals. For each call

A stockbroker calls on potential clients from referrals. For each call, there is a 20% chance that the client will decide to invest with the stockbroker’s firm. Forty percent of thos...

Q: Cinéma Le Méliès is a small movie theatre in Grenoble, France

Cinéma Le Méliès is a small movie theatre in Grenoble, France. After the release of a widely anticipated Marvel movie, like the Avengers: Endgame, the number of adult and children’s tickets sold at th...

Q: J&G Bank receives an average of 30,000 credit

J&G Bank receives an average of 30,000 credit card applications each month. Approximately 60% of them are approved. Each customer charges an average of $2,000 to his or her credit card each month. App...

Q: With the growth of digital photography, a young entrepreneur is considering

With the growth of digital photography, a young entrepreneur is considering establishing a new business, Wild World Photography. She estimates that the average number of safari trail bookings per ye...

Q: An auditor found an expense receipt for $179.24 without

An auditor found an expense receipt for $179.24 without a name. Write a left table lookup function that would identify the sales rep in the Travel Expenses database.

Q: The wedding banquet prices at a famous hotel in Singapore continue to

The wedding banquet prices at a famous hotel in Singapore continue to increase on a yearly basis. The booking volume this year is estimated to be at 3,000 tables (for 10 persons per table) and is pr...

Q: The board of directors of Bolt Electric Vehicles (BEV) is

The board of directors of Bolt Electric Vehicles (BEV) is considering replacing its original model, the BEV Neo, with a new model, the BEV-Alpha, which they feel will appeal to the younger demographic...

Q: Few companies take the time to estimate the value of a good

Few companies take the time to estimate the value of a good customer (and often spend little effort to keep one). Suppose that a customer at a restaurant spends, on average, R per visit and comes F ti...

Q: Adam is 24 years old and has a 401(k)

Adam is 24 years old and has a 401(k) plan through his employer, a large financial institution. His company matches 50% of his contributions up to 6% of his salary. He currently contributes the maximu...

Q: Jennifer Bellin has been put in charge of planning her company’s annual

Jennifer Bellin has been put in charge of planning her company’s annual leadership conference. The dates of the conference have been determined by her company’s exe...

Q: Experiment with the portfolio allocation model to attempt to find the best

Experiment with the portfolio allocation model to attempt to find the best solution that maximizes the expected annual return and meets the total weighted risk constraint.

Q: The Bose Theater, a community playhouse, needs to determine the

The Bose Theater, a community playhouse, needs to determine the lowest-cost production budget for an upcoming show. Specifically, they have to determine which set pieces to construct and which, if any...

Q: A franchise of a chain of Mexican restaurants wants to determine the

A franchise of a chain of Mexican restaurants wants to determine the best location to attract customers from three suburban neighborhoods. The coordinates of the three suburban neighborhoods are as fo...

Q: ElectroMart wants to identify a location for a warehouse that will ship

ElectroMart wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given here. Develop a model to find the best location...

Q: The demand for organic chicken meat is quite sensitive to price.

The demand for organic chicken meat is quite sensitive to price. Typically, there is an inverse relationship between its demand and price—when price decreases, demand increases and vice versa. The pri...

Q: Use the CHOOSE function to develop a database query for the Time

Use the CHOOSE function to develop a database query for the Time Spent data that will complete the following table for any individual specified in the top left corner: Each empty cell should contain o...

Q: An IT support group at Thomson State College has seven projects to

An IT support group at Thomson State College has seven projects to complete. The time and project deadlines (both in days) are shown next. a. Develop a spreadsheet model for this situation. b. Use a s...

Q: Implement the model you developed in Problem 1 on a spreadsheet and

Implement the model you developed in Problem 1 on a spreadsheet and construct a one-way data table to estimate the price for which profit is maximized.

Q: For the Schoch Museum, use data tables to investigate the impacts

For the Schoch Museum, use data tables to investigate the impacts of the percentage assumptions used in the model on the cumulative funds raised by the fifth year.

Q: A local supermarket orders 27 copies of a monthly magazine. Depending

A local supermarket orders 27 copies of a monthly magazine. Depending on the cover story, demand for the magazine varies. The supermarket purchases the magazines for $1.73 and sells them for $4.03. An...

Q: For the engineering admissions, apply two-way data tables to

For the engineering admissions, apply two-way data tables to analyze the impact on extra funds needed and the number of students who accept scholarships as the acceptance rate and number of offers var...

Q: Vision Clinic in Brussels, Belgium, specializes in laser-assisted

Vision Clinic in Brussels, Belgium, specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening exams to determine their candidacy for the surgery. If...

Q: A company is trying to predict the long-run market share

A company is trying to predict the long-run market share of a new men’s deodorant.10 Based on initial marketing studies, they believe that 40% of new purchasers in this market will ultimately try this...

Q: For the Sunday bazaar model that you developed, use the Scenario

For the Sunday bazaar model that you developed, use the Scenario Manager to evaluate profitability for the following scenarios:

Q: Think of any retailer that operates many stores throughout the country,

Think of any retailer that operates many stores throughout the country, such as Old Navy, Hallmark Cards, or Vineyard Vines, to name just a few. The retailer is often seeking to open new stores and ne...

Q: For the gasoline usage, apply the Goal Seek tool to find

For the gasoline usage, apply the Goal Seek tool to find the fuel economy needed to consume 20 gallons per month, with all other data being constant.

Q: Suppose that an electricity supplier in your country offers specific rates to

Suppose that an electricity supplier in your country offers specific rates to domestic consumers. For the first 2,000 units of electricity consumed, it charges €0.14 per unit; and if more than 2,000 u...

Q: For the stockbroker, use the Goal Seek tool to find the

For the stockbroker, use the Goal Seek tool to find the number of calls needed to achieve a broker commission of $5,000.

Q: For the ballet company, use the Goal Seek tool to find

For the ballet company, use the Goal Seek tool to find the number of solicitations required to achieve $150,000 in total donations.

Q: A manufacturing company make their sales by visiting the customers personally to

A manufacturing company make their sales by visiting the customers personally to market their products. They want to determine the impact of these sales visits on the total profit earned by their sale...

Q: Construct an influence diagram for profit in the single-period purchase

Construct an influence diagram for profit in the single-period purchase decision (Newsvendor Model) discussed in this chapter. Use Excel’s Formula Auditing capability to demonstrate the relationship b...

Q: Construct an influence diagram for the net revenue in the overbooking decision

Construct an influence diagram for the net revenue in the overbooking decision model discussed in this chapter. Use Excel’s Formula Auditing capability to demonstrate the relationship between the spre...

Q: Construct an influence diagram for the staffing model in Example 11.

Construct an influence diagram for the staffing model in Example 11.7. Data from Example 11.7: Suppose that the manager of a loan-processing department wants to know how many employees will be need...

Q: Use the RAND function to generate 100 exponential random variates with the

Use the RAND function to generate 100 exponential random variates with the mean 1.5, and create a frequency distribution and a histogram with bins of width 0.5. Apply the chi-square goodness of fit te...

Q: A metal pistons manufacturer conducts a marketing research and finds that for

A metal pistons manufacturer conducts a marketing research and finds that for every 10 pistons made, an average of 12% of its pistons are rejected because they are not correctly sized. Generate 20 ran...

Q: In the Olympic bid proposal discussed, ticket sales revenue was estimated

In the Olympic bid proposal discussed, ticket sales revenue was estimated to be a triangular distribution with minimum= $560 million, maximum= $600 million, and most likely = $600 million. Generate a...

Q: A research study on the duration of two-month-old

A research study on the duration of two-month-old babies’ smile was carried out. Analysts created the following distribution, which were assumed to be uniform over various intervals,...

Q: Develop an Excel template for computing the IQ scores obtained by males

Develop an Excel template for computing the IQ scores obtained by males and females based on the brain size (in count obtained from MRI scans, count/10,000), height (in inches) and weight (in pounds)....

Q: Use the profit model developed to implement a financial simulation model for

Use the profit model developed to implement a financial simulation model for a new product proposal and determine a distribution of profits using the discrete distributions below for the unit cost, de...

Q: The Excel file Outsourcing Decision Model is a spreadsheet implementation of the

The Excel file Outsourcing Decision Model is a spreadsheet implementation of the model. The model calculates the total cost for manufacturing and outsourcing. The key outputs in the model are the diff...

Q: Suppose that the daily purchase of a stock any given day is

Suppose that the daily purchase of a stock any given day is normally distributed with a mean of 3% and a standard deviation of 0.5%. In predicting the long run market share, a research study shows an...

Q: For the Sunday bazaar model, suppose that the expected crowd is

For the Sunday bazaar model, suppose that the expected crowd is normally distributed with a mean of 4,000 and a standard deviation of 350, and the average expenditure has a triangular distribution wit...

Q: A professional football team is preparing its budget for the next year

A professional football team is preparing its budget for the next year. One component of the budget is the revenue that they can expect from ticket sales. The home venue, Dylan Stadium, has five diffe...

Q: The owner of Wild World Photography believes that the average number of

The owner of Wild World Photography believes that the average number of safari trail bookings per year can be estimated by triangular distribution with a minimum of 10, a maximum of 22, and a most lik...

Q: A financial consultant has an average of seven customers he consults with

A financial consultant has an average of seven customers he consults with each day; assume a Poisson distribution. The consultant’s overhead requires that he consult with at least five customers per d...

Q: The manager of the extended-stay hotel believes that the number

The manager of the extended-stay hotel believes that the number of rooms rented during any given week has a triangular distribution with minimum 32, most likely 38, and maximum 50. The weekly price is...

Q: A manufacturing company is considering investing in a new machine that costs

A manufacturing company is considering investing in a new machine that costs €38,000. Its use is expected to generate a cash flow of about €10,000 per year for each of the next five years. However, th...

Q: Cinéma Le Méliès is a small movie theatre in Grenoble, France

Cinéma Le Méliès is a small movie theatre in Grenoble, France. After the release of a typical, widely anticipated Marvel movie, such as the Avengers: Endgame, the number of adult and children’s ticket...

Q: A college graduate who is living in Edinburgh, the United Kingdom

A college graduate who is living in Edinburgh, the United Kingdom, expects to earn a monthly salary of £598. The Excel file UK Cost of Living shows the comparative salaries in other citie...

Q: The Oxford Theater produces plays and musicals for a regional audience.

The Oxford Theater produces plays and musicals for a regional audience. For a typical performance, the theater sells at least 250 tickets and occasionally reaches its capacity of 600 seats. Most often...

Q: UOB Bank receives a significant number of housing loan applications each month

UOB Bank receives a significant number of housing loan applications each month, with an average of 5,000 and a standard deviation of 463, normally distributed. The application approval rate varies bet...

Q: Sturgill Manufacturing Inc. needs to predict the numbers of machines and

Sturgill Manufacturing Inc. needs to predict the numbers of machines and employees required to produce its planned production for the coming year. The plant runs three shifts continuously during the w...

Q: O’Brien Chemicals makes three types of products: industrial cleaning, chemical

O’Brien Chemicals makes three types of products: industrial cleaning, chemical treatment, and some miscellaneous products. Each is sold in 55-gallon drums. The selling price and unit...

Q: The board of directors of Bolt Electric Vehicles (BEV) is

The board of directors of Bolt Electric Vehicles (BEV) is considering replacing its original model, the BEV-Neo, with a new model, the BEV-Alpha, which they feel will appeal to the younger demographic...

Q: The weekly demand of a slow-moving product has the following

The weekly demand of a slow-moving product has the following probability mass function: Use VLOOKUP to generate 25 random variates from this distribution.

Q: Malaysia’s state water tariffs are one of the cheapest in comparison to

Malaysia’s state water tariffs are one of the cheapest in comparison to its neighbor countries. The cost of a meter installation is RM10 per household. The daily cost of supplying water is assumed to...

Q: A regional tax preparation firm competes with such national chains as H

A regional tax preparation firm competes with such national chains as H&R Block. It is considering expanding and needs a financial model to analyze the decision to open a new store. Key factors affect...

Q: For the profit model developed, suppose that the demand is uniform

For the profit model developed, suppose that the demand is uniform with a minimum of 35,000 and maximum of 60,000; fixed costs are normal with a mean of $400,000 and a standard deviation of $25,000; a...

Q: Use the Newsvendor Model spreadsheet to set up and run a Monte

Use the Newsvendor Model spreadsheet to set up and run a Monte Carlo simulation assuming that demand is triangular with minimum value = 40, maximum value = 50, and most likely value = 47. Find the dis...

Q: The Excel file Payroll Data provides hourly salaries for a group of

The Excel file Payroll Data provides hourly salaries for a group of employees. Create an Excel template that allows the user to select an employee by employee ID, enter the number of regular hours and...

Q: A bakery stall at a local supermarket bakes 100 loaves of banana

A bakery stall at a local supermarket bakes 100 loaves of banana bread every morning for sale. The cost of baking a loaf of banana bread is $3 and it sells for $5. The average expected sales at the st...

Q: Develop and analyze a simulation model for Vision Clinic with the following

Develop and analyze a simulation model for Vision Clinic with the following assumptions. Assume that the demand is uniform between 110 and 160 per week and that anywhere between 10% and 20% of prospec...

Q: The following table shows the number and frequency of books bought per

The following table shows the number and frequency of books bought per customer, on an hourly basis, at a bookstore from 10am to 9pm on a specific day. Use VLOOKUP to generate 20 random variates from...

Q: DemiGod Shipping Company forecasts a 10% increase in its sales over

DemiGod Shipping Company forecasts a 10% increase in its sales over the year 2019. Its assets and liabilities, at the end of 2018, amount to $20 billion and $7 billion respectively. Sales for this pe...

Q: In Jennifer Bellin’s leadership conference project, suppose that the activity times

In Jennifer Bellin’s leadership conference project, suppose that the activity times are uncertain. Estimated ranges for these times are shown in the table below. Develop a spreadshee...

Q: A front office receptionist of a given company answers the incoming calls

A front office receptionist of a given company answers the incoming calls on multi-line telephones. The number of calls successfully attended by the receptionist within each 5-minute period is recorde...

Q: E-Globex is a moneychanger headquartered in Kuala Lumpur, Malaysia

E-Globex is a moneychanger headquartered in Kuala Lumpur, Malaysia. It quotes the current US Dollar to Malaysian Ringgit exchange rate to be RM4.1740 for every 1 US Dollar. The daily price changes ove...

Q: The Miller-Orr model in finance addresses a firm’s problem of

The Miller-Orr model in finance addresses a firm’s problem of managing its cash position by purchasing or selling securities at a transaction cost in order to lower or raise its cash position. That is...

Q: For the car wash simulation model, use data tables to find

For the car wash simulation model, use data tables to find the distributions for the maximum number in the queue, maximum waiting time, average waiting time per customer, and total idle time. Use 100...

Q: In many queueing situations, the time between arrivals and service times

In many queueing situations, the time between arrivals and service times are assumed to have exponential distributions. Modify the car wash model to simulate a queueing system with an exponential arri...

Q: Construct PivotTables showing the counts of region versus social media platform market

Construct PivotTables showing the counts of region versus social media platform market share, and tablet versus mobile device usage in Asia in the Excel file Social Media Market share. What might you...

Q: The time required to play the Pandemic board game is uniformly distributed

The time required to play the Pandemic board game is uniformly distributed between 45 and 60 minutes. Use formula to obtain a sample of 50 outcomes and compute the mean, minimum, maximum, and standard...

Q: The exponential distribution of the amount of time a car battery lasts

The exponential distribution of the amount of time a car battery lasts has a mean of 4 years. Generate 20 random variates from this distribution as whole Numbers.

Q: Historical data shows that the birth weight of a random pool of

Historical data shows that the birth weight of a random pool of 3,226 newborn babies with a mean of 3.39 kg and a standard deviation of 0.55 kg per baby, is normally distributed, but never more than 6...

Q: A formula in financial analysis is the following: Return on equity

A formula in financial analysis is the following: Return on equity = net profit margin * total asset turnover * equity multiplier. Suppose that the equity multiplier is fixed at 3.5, but that the net...

Q: A government body is putting a large project out for low bid

A government body is putting a large project out for low bid. Bids are expected from eight contractors and will have a normal distribution with a mean of $4.2 million and a standard deviation of $0.27...

Q: Suggest additional generic examples of linear optimization models in the format based

Suggest additional generic examples of linear optimization models in the format based on your work experience, personal interests (hobbies, etc.), or information found in business articles.

Q: Malloy Milling grinds calcined alumina to a standard granular size. The

Malloy Milling grinds calcined alumina to a standard granular size. The mill produces two different size products from the same raw material. Regular grind can be produced at a rate of 10,000 pounds p...

Q: Implement the linear optimization model that you developed for Valencia Products on

Implement the linear optimization model that you developed for Valencia Products on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding c...

Q: Implement the linear optimization model that you developed for ColPal Products on

Implement the linear optimization model that you developed for ColPal Products on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding con...

Q: Implement the linear optimization model that you developed for Burger Office Equipment

Implement the linear optimization model that you developed for Burger Office Equipment on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the bin...

Q: Use PivotTables to find the number of loans by different purposes,

Use PivotTables to find the number of loans by different purposes, marital status, and credit risk in the Excel file Credit Risk Data (Base Data worksheet).

Q: Dion’s Décor shop has three bestseller products. Dion has a budget

Dion’s Décor shop has three bestseller products. Dion has a budget of $2,500 to purchase these products from an outstation wholesale warehouse. The cost and the profits...

Q: Implement the linear optimization model that you developed for Bangs Leisure Chairs

Implement the linear optimization model that you developed for Bangs Leisure Chairs on a spreadsheet and use Solver to find an optimal solution. a. Interpret the Solver Answer Report, identify the bin...

Q: Implement the linear optimization model that you developed for the Flower Aurora

Implement the linear optimization model that you developed for the Flower Aurora shop on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report and identify the b...

Q: A farmer plans to plant both corn and carrot on a 100

A farmer plans to plant both corn and carrot on a 100-hectare land. To meet his requirements, he must plant at least 20 hectares with corn and 35 hectares with carrot. In order to maximize his profit,...

Q: For the Valencia Products model, graph the constraints and identify the

For the Valencia Products model, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the opt...

Q: For the ColPal model, graph the constraints and identify the feasible

For the ColPal model, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optimal soluti...

Q: Classify the following descriptions of constraints as bounds, limitations, requirements

Classify the following descriptions of constraints as bounds, limitations, requirements, proportional relationships, or balance constraints: a. A production line is sufficiently meeting its customers’...

Q: For the investment situation, apply the same logic as we did

For the investment situation, apply the same logic as we did for the Crebo Manufacturing model in the text to find the optimal solution. Compare your answer with the Solver solution.

Q: Most cake recipes have the basic ingredients of eggs, oil,

Most cake recipes have the basic ingredients of eggs, oil, flour, and milk. Susan just baked a cake, using 85% of the eggs, 73% of the oil, 78% of the flour, and 92% of the milk that she bought, by fo...

Q: Ascent Constructions builds four different types of residential spaces: flats,

Ascent Constructions builds four different types of residential spaces: flats, condominiums, single-story houses, and double-story houses. Each type requires basic development in five different units:...

Q: The Excel file MBA Motivation and Salary Expectations provides data on students’

The Excel file MBA Motivation and Salary Expectations provides data on students’ pre-MBA salary and post-MBA salary expectations. Define range names for each of these ranges and then use the range nam...

Q: Sweet Tea markets three blends of tea: English breakfast, jasmine

Sweet Tea markets three blends of tea: English breakfast, jasmine, and genmaicha. The firm uses tea leaves from its sources in India, China, and Japan. Net profit per pound for each blend is: $0.60 fo...

Q: Review the portfolio allocation model in this chapter. Identify the decision

Review the portfolio allocation model in this chapter. Identify the decision variables, objective function, and constraints in simple verbal statements, and mathematically formulate the linear optimiz...

Q: The Social Health Group is a nonprofit organization that conducts health talks

The Social Health Group is a nonprofit organization that conducts health talks for the local public. The organization conducts these talks at two different venues: Iron Age Hall and Virtual Town Amphi...

Q: Boris’ department store chain is planning to open a new store.

Boris’ department store chain is planning to open a new store. It needs to decide how to allocate the 100,000 square feet of available floor space among seven departments. Data on ex...

Q: DwiFurni, a furniture store, is conducting a sale at a

DwiFurni, a furniture store, is conducting a sale at a local market. The store outsources its furniture production and has a budget of $30,000 for procurements costs. The table Data for Problem 33 sho...

Q: The Little Investment Advisors problem and illustrated scaling issues. In answering

The Little Investment Advisors problem and illustrated scaling issues. In answering the following questions, be sure to scale the model appropriately. a. How would the results in Figure 13.26 change i...

Q: StraitCarrier and SunShipping are two logistics companies based in Malaysia. Both

StraitCarrier and SunShipping are two logistics companies based in Malaysia. Both companies offer shipment services to four different neighboring countries, and the cost of shipping one container from...

Q: Box Tile Company makes ceramic and porcelain tile for residential and commercial

Box Tile Company makes ceramic and porcelain tile for residential and commercial use. They produce three different grades of tile (for walls, residential flooring, and commercial flooring), each of wh...

Q: Valencia Products makes automobile radar detectors and assembles two models: LaserStop

Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these...

Q: The Hansel Corporation, located in Bangalore, India, makes plastics

The Hansel Corporation, located in Bangalore, India, makes plastics materials that are mixed with various additives and reinforcing materials before being melted, extruded, and cut into small pellets...

Q: The background for this case was introduced in Chapter 2. For

The background for this case was introduced in Chapter 2. For this part of the case, summarize the numerical data using frequency distributions and histograms, cross-tabulations, PivotTables, and desc...

Q: The Excel file Retail Survey provides data about customers’ preferences for denim

The Excel file Retail Survey provides data about customers’ preferences for denim jeans. Use PivotTables and slicers to draw conclusions about how preferences differ by gender and age group and summar...

Q: FujiFarm produces four types of vegetables with variable costs of $2

FujiFarm produces four types of vegetables with variable costs of $2.80, $3.54, $1.07, and $2.23 per acre. Due to an increment in the cost of fertilizers, the variable cost of each of the vegetables w...

Q: Reddy & Rao (R&R) is a small company

Reddy & Rao (R&R) is a small company in India that makes handmade, artistic chairs for commercial businesses. The company makes four models. The time required to make each of the models and co...

Q: Joan Weasley receives a reward bonus semi-annually from her company

Joan Weasley receives a reward bonus semi-annually from her company: $3,000 on 1st June and $3,500 on 1st December. She must pay $1,500 as an insurance installment for each of the January, April, July...

Q: Suppose that David Samuel wants to invest in three company shares:

Suppose that David Samuel wants to invest in three company shares: APPL, FB, and IBM. He decides to do some market research before he invests his money in these shares. The following table provides in...

Q: Starbucks coffee company uses three types of cup sizes for selling its

Starbucks coffee company uses three types of cup sizes for selling its bestseller drink Mocha Frappuccino: Tall, (8 ounces), Grande (12 ounces), Venti (16 ounces), which have unit profits of $0.60, $0...

Q: Fruity Juices, Inc., produces five different flavors of fruit juice

Fruity Juices, Inc., produces five different flavors of fruit juice: apple, cherry, pomegranate, orange, and pineapple. Each batch of product requires processing in three departments (blending, strain...

Q: WoodFurni is a furniture manufacturer company that produces three main types of

WoodFurni is a furniture manufacturer company that produces three main types of furniture: chairs, tables, and wardrobes. All three products require design and execution, and grinding and polishing be...

Q: MK Manufacturing produces compressor and turbine blades for jet engines. The

MK Manufacturing produces compressor and turbine blades for jet engines. The blades are manufactured from an alloy that is a mix of aluminum and titanium. Sheaths are part of the assembly that keep th...

Q: A paper mill produces three grades of paper: X, Y

A paper mill produces three grades of paper: X, Y, and Z. The mill has a budget of €100,000 to invest in the production of these three different types of paper. The cost per ton and e...

Q: Bangs Leisure Chairs produces three types of handcrafted outdoor chairs that are

Bangs Leisure Chairs produces three types of handcrafted outdoor chairs that are popular for beach, pool, and patios: sling chairs, Adirondack chairs, and hammocks. The unit profit for these products...

Q: Conduct a Pareto analysis for the number of minutes that flights are

Conduct a Pareto analysis for the number of minutes that flights are late in the Global Airline Data Excel file. Interpret the results.

Q: FlowerAurora, a florist and gifts shop, prepares three types of

FlowerAurora, a florist and gifts shop, prepares three types of flower bouquets to sell on the convocation day at a local university. The bouquets are made from four types of flowers: Gypsophila, gerb...

Q: Solve Valencia Products to ensure that the number of units produced is

Solve Valencia Products to ensure that the number of units produced is integer-valued. How much difference is there between the optimal integer solution objective function and the linear optimization...

Q: Timberland Co. is an automobile manufacturer based in Australia. It

Timberland Co. is an automobile manufacturer based in Australia. It has four plants and six sales depots. Timberland produces 165 cars and receives a demand for 86 cars. Since production is more than...

Q: A local university is considering offering five new programs for the next

A local university is considering offering five new programs for the next academic year. As a result, the university’s board of management needs to determine which programs to fund....

Q: Puma SE, a German multinational company that manufactures athletic and casual

Puma SE, a German multinational company that manufactures athletic and casual apparel, footwear, and accessories, is launching their new jersey for the upcoming soccer season. They need to determine w...

Q: Rita is a part-time business student who works full time

Rita is a part-time business student who works full time and is socially very active. She recognizes the challenge of eating a balanced diet and wants to minimize cost while meeting her basic nutritio...

Q: Josh Steele manages a professional choir in a major city. His

Josh Steele manages a professional choir in a major city. His marketing plan is focused on generating additional local demand for concerts and increasing ticket revenue and also gaining attention at t...

Q: SnapHouse is a local property agents’ team who make profit on renting

SnapHouse is a local property agents’ team who make profit on renting and selling residential units. Currently, they are focusing on a newly developed residential area and are helping the developer se...

Q: Foodpanda is an online food delivery brand headquartered in Berlin, Germany

Foodpanda is an online food delivery brand headquartered in Berlin, Germany, and operating in over 10 countries. It is establishing a new business to serve customers in Selangor, a state on the west c...

Q: A manufacturer of kitchen appliances is preparing to set the price on

A manufacturer of kitchen appliances is preparing to set the price on a new blender. Demand is thought to depend on the price and is represented by the model D = 2,000 - 3P The accounting department e...

Q: Use Excel’s filtering capability in the Car database to extract a

Use Excel’s filtering capability in the Car database to extract a. all Japanese cars. b. all cars having more than 400 horsepower. c. all cars having less than 8 cylinders and weighing more than 3,500...

Q: The demand for organic chicken meat is quite sensitive to price.

The demand for organic chicken meat is quite sensitive to price. Typically, there is an inverse relationship between its demand and price; when price decreases, demand increases and vice versa. One ma...

Q: Intel, the largest semiconductor manufacturing company in the world, sells

Intel, the largest semiconductor manufacturing company in the world, sells two major types of computer chips, type A and type B. The sales of these two chips are not independent of each other (in econ...

Q: For the pricing decision model, suppose that the company wants to

For the pricing decision model, suppose that the company wants to keep the price at a maximum of $500. Note that the solution in Figure will no longer be feasible. Modify the spreadsheet model to incl...

Q: In the hotel pricing problem, suppose that the hotel is considering

In the hotel pricing problem, suppose that the hotel is considering adding suites to its room mix. Based on an analysis of local competitors, suites can sell for a rate of $180, and they expect to sel...

Q: A franchise of a chain of H&M, a Swedish

A franchise of a chain of H&M, a Swedish multinational clothing retail company, wants to determine the best location to attract customers from three shopping malls. The coordinates of the three sh...

Q: ElectroMart wants to identify a location for a warehouse that will ship

ElectroMart wants to identify a location for a warehouse that will ship to five retail stores. The coordinates and annual number of truckloads are given here. Develop and solve a model to find the bes...

Q: We noted that the least-squares coefficients in a regression model

We noted that the least-squares coefficients in a regression model are found by minimizing the sums of squares of the errors, as given in equation. This is a nonlinear optimization problem. Using the...

Q: Many manufacturing situations, for example, the production of such large

Many manufacturing situations, for example, the production of such large and complex items as aircraft or machines, exhibit a learning effect in which the production time per unit decreases as more un...

Q: ToyDoc is a major toy manufacturer. Its financial advisor is analyzing

ToyDoc is a major toy manufacturer. Its financial advisor is analyzing the effect of the direct material cost of plastic used to make the toys on profits earned for two of their main products. These d...

Q: Dilan is a property investor. Recently he has been interested to

Dilan is a property investor. Recently he has been interested to invest in three different types of property: a shoplot, a condominium, and a double-story house. The shoplot is a high-risk investment,...

Q: Filter the data in the Cereal database to obtain the cereals that

Filter the data in the Cereal database to obtain the cereals that are of type C. What are the average calories and total sales for this type of cereal?

Q: An IT support group at Thomson State College has seven projects to

An IT support group at Thomson State College has seven projects to complete. The time each will take and project deadlines (both given in number of days) are shown next. a. Sequence the projects to mi...

Q: Suppose the distances that Mohan Raja, a mechanical technician for Canon

Suppose the distances that Mohan Raja, a mechanical technician for Canon who repairs and services photocopy machines, travels between five different companies that rent photocopy machines from Canon a...

Q: For the Brewer Services scenario described in this chapter, suppose that

For the Brewer Services scenario described in this chapter, suppose that five permanent employees are hired. Find an optimal solution to minimize the number of part-time employees needed.

Q: ACTN Partners, an accounting firm, recently received project offers from

ACTN Partners, an accounting firm, recently received project offers from three different companies, A, B, and C, to analyze and prepare accounting data. The companies need the analysis and report to b...

Q: Panasonic Corporation is a multinational electronics corporation headquartered in Osaka, Japan

Panasonic Corporation is a multinational electronics corporation headquartered in Osaka, Japan. In the face of tight competition in the electronics industry and to meet the high level of demand, Panas...

Q: Steven is a 20-year-old male who suffers from

Steven is a 20-year-old male who suffers from chronic malnutrition. His doctor advices him to follow a dietary plan that will help him recover efficiently. He would need to take at least 400 grams of...

Q: Mix&Match Ltd., a small fertilizer manufacturer, produces two

Mix&Match Ltd., a small fertilizer manufacturer, produces two active formulae of fertilizer mixtures. The mixtures must contain a minimum quantity of four different nutrients: 45 grams of nutrient...

Q: Hatch Financial, which recently absorbed another firm, is now downsizing

Hatch Financial, which recently absorbed another firm, is now downsizing and must relocate five information systems analysts from recently closed locations. Unfortunately, there are only three positio...

Q: For the Valencia Products scenario, use the spreadsheet model to answer

For the Valencia Products scenario, use the spreadsheet model to answer the following questions by changing the parameters and re-solving the model. Answer each question independently relative to the...

Q: Obtain the Solver Sensitivity report for the GAC transportation model.

Obtain the Solver Sensitivity report for the GAC transportation model. a. What must the unit shipping cost be to make it attractive to ship from Marietta to Cleveland instead of from Minneapolis? b. W...

Q: Use the Excel file Credit Risk Data that was introduced in this

Use the Excel file Credit Risk Data that was introduced in this chapter to perform the following activities: a. Compute the combined checking and savings account balance for each record in the Base Da...

Q: Use the Sensitivity Report for the Camm Textiles scenario (Figure 15

Use the Sensitivity Report for the Camm Textiles scenario (Figure 15.37) to answer the following: a. Explain the reduced cost (0.14) for Fabric 2 Purchased in terms of the original data, and why it ma...

Q: Dion must now purchase at least 5 units of Product A,

Dion must now purchase at least 5 units of Product A, 15 units of Product B, and 10 units of Product C to fulfill his demand. Use Solver to find an optimal solution and compare the Solver solution wit...

Q: Bangs Leisure Chairs. The Solver Sensitivity Report for the optimal solution

Bangs Leisure Chairs. The Solver Sensitivity Report for the optimal solution is shown in Figure 15.38. Clearly explain the information it provides.

Q: Model and solve an optimization model for the Morton Supply Company.

Model and solve an optimization model for the Morton Supply Company. Obtain the Solver Sensitivity Report for your solution, and clearly explain all the key information in language that the production...

Q: Model and solve an optimization model for planting corns and carrots.

Model and solve an optimization model for planting corns and carrots. Using the Solver Sensitivity Report, answer the following questions, explaining what information you used in Sensitive Report. a....

Q: For Susan’s cake recipe scenario, obtain the Solver Sensitivity Report and

For Susan’s cake recipe scenario, obtain the Solver Sensitivity Report and write a short memo to Susan explaining the sensitive information in language that she can understand.

Q: For Dara’s investment situation, obtain the Solver Sensitivity Report and interpret

For Dara’s investment situation, obtain the Solver Sensitivity Report and interpret the information, making recommendations that Dara might consider for her portfolio.

Q: StraitCarrier and SunShipping, obtain the Solver Sensitivity Report and write a

StraitCarrier and SunShipping, obtain the Solver Sensitivity Report and write a short memo to the directors of both the companies explaining your results.

Q: For Problem (Shafer Office Supplies), obtain the Solver Sensitivity Report

For Problem (Shafer Office Supplies), obtain the Solver Sensitivity Report and answer the following questions: a. Suppose that 500 units of extra supply are available (and that the cost of this extra...

Q: For the ColPal Products scenario, use the spreadsheet model to answer

For the ColPal Products scenario, use the spreadsheet model to answer the following question by changing the parameters and re-solving the model. Answer each question independently relative to the o...

Q: Apply the Advanced Filter to the Credit Risk Data (Base Data

Apply the Advanced Filter to the Credit Risk Data (Base Data worksheet) to find the following: a. All new car loans obtained for single females. b. All furniture loans obtained for single individuals...

Q: For the Hansel Corporation, obtain the Solver Sensitivity Report and use

For the Hansel Corporation, obtain the Solver Sensitivity Report and use it to answer the following: a. A labor strike in India leads to a shortage of 20,000 units of additive C. What should the produ...

Q: For the nonlinear pricing decision model, suppose that the company wants

For the nonlinear pricing decision model, suppose that the company wants to keep the price at a maximum $300. Note that the solution in Figure 14.19 will no longer be feasible. Modify the spreadsheet...

Q: Figure 15.39 shows the Solver Sensitivity Report for the Markowitz

Figure 15.39 shows the Solver Sensitivity Report for the Markowitz portfolio model. a. Explain how to interpret the Lagrange multiplier value for the target portfolio return. b. Suppose the target ret...

Q: Obtain the Solver Sensitivity Report for the Hal Chase portfolio optimization model

Obtain the Solver Sensitivity Report for the Hal Chase portfolio optimization model. Explain how to interpret the Lagrange multipliers for the constraints.

Q: Marketing agents have various media alternatives in which to advertise and must

Marketing agents have various media alternatives in which to advertise and must determine which to use, the number of insertions in each, and the timing of insertions to maximize advertising effective...

Q: Box Tile Company, use the auxiliary variable technique to handle the

Box Tile Company, use the auxiliary variable technique to handle the bound constraints on grade I and grade III tiles and obtain the Solver Sensitivity Report. Answer the following: a. Explain the sen...

Q: For Starbucks coffee company, formulate and solve a linear optimization model

For Starbucks coffee company, formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo to the outlet manager explaining the sensitivity informat...

Q: For the Fruity Juices scenario, formulate and solve a linear optimization

For the Fruity Juices scenario, formulate and solve a linear optimization model using the auxiliary variable cells method and write a short memo explaining the sensitivity information.

Q: For WoodFurni, solve the model using auxiliary variables. Obtain the

For WoodFurni, solve the model using auxiliary variables. Obtain the Solver Sensitivity Report, and answer the following: a. Explain the sensitivity information for the objective coefficients. What ha...

Q: Hahn Engineering would like to increase its return, but the project

Hahn Engineering would like to increase its return, but the project manager knows that this will require more cash and/or personnel. Conduct a what-if analysis of the optimal solution as the cash limi...

Q: In the Credit Risk Data file, use database functions to find

In the Credit Risk Data file, use database functions to find the average amount of savings for each of the situations listed in Problem 16. Data from Problem 16: Apply the Advanced Filter to the Cred...

Q: For the Burger Office Equipment scenario, use the spreadsheet model to

For the Burger Office Equipment scenario, use the spreadsheet model to answer the following questions by changing the parameters and re-solving the model. Answer each question independently relative t...

Q: Jordan owns a magazine stall and he has 150 old magazines in

Jordan owns a magazine stall and he has 150 old magazines in storage. He is planning to sell some of his magazines with the highest price to gain a profit of $8.00 and some with the lowest price to ga...

Q: Analyze the sensitivity of the optimal solution for the local university as

Analyze the sensitivity of the optimal solution for the local university as the total cost and available lecturers are varied. Write a short summary memo to the university management in which you outl...

Q: Construct a what-if analysis for Foodpanda as the delivering goal

Construct a what-if analysis for Foodpanda as the delivering goal varies from 15 to 35 minutes in increments of 5 minutes.

Q: Use Excel charts to visualize the solution for WoodFurni. Use the

Use Excel charts to visualize the solution for WoodFurni. Use the Solver Answer Report and the Sensitivity Report to facilitate your analysis.

Q: Use Excel charts to visualize the solution for the J&M

Use Excel charts to visualize the solution for the J&M Manufacturing problem using the Solver Sensitivity Report with auxiliary variables.

Q: Obtain the Answer and Sensitivity Reports for Dara’s investment scenario. Develop

Obtain the Answer and Sensitivity Reports for Dara’s investment scenario. Develop a set of charts that visualize the key information in these reports.

Q: The Body Shop has recently launched two new hand cream varieties:

The Body Shop has recently launched two new hand cream varieties: Rose and Lotus. It costs $2.75 to purchase the fragrance needed for each tube of Rose hand cream and $1.56 for each tube of Lotus hand...

Q: Suppose that Sue is considering three stocks in which to invest.

Suppose that Sue is considering three stocks in which to invest. She has $20,000 to invest, and so she decides to equally invest in all the three stocks. The expected return is 20% for stock A, 10% fo...

Q: Figure 15.32 shows the Solver Sensitivity Report after solving the

Figure 15.32 shows the Solver Sensitivity Report after solving the Crebo Manufacturing. Using only the information in the Sensitivity Report, answer the following questions. a. Explain the value of th...

Q: For the Bicycle Inventory database, use database functions to find the

For the Bicycle Inventory database, use database functions to find the following: a. The total number of leisure bicycles on hand. b. The average purchase cost and selling price of road bicycles.

Q: Figure 15.33 shows the Solver Sensitivity Report for Valencia Products

Figure 15.33 shows the Solver Sensitivity Report for Valencia Products. Using only the information in the Sensitivity Report, answer the following questions, explaining what information you used in th...

Q: Figure 15.34 shows the Solver Sensitivity Report for the ColPal

Figure 15.34 shows the Solver Sensitivity Report for the ColPal Products scenario. Using only the information in the Sensitivity Report, answer the following questions, explaining what information you...

Q: Figure 15.35 shows the Solver Sensitivity Report for the Burger

Figure 15.35 shows the Solver Sensitivity Report for the Burger Office Equipment scenario. Using only the information in the Sensitivity Report, answer the following questions, explaining what informa...

Q: Use the Outsourcing Decision Model Excel file to compute the cost of

Use the Outsourcing Decision Model Excel file to compute the cost of in-house manufacturing and outsourcing for the following levels of demand: 200, 600, 1,000, and 1,400. Use this information to set...

Q: For the DoorCo Corporation decision, suppose that the probabilities of the

For the DoorCo Corporation decision, suppose that the probabilities of the three scenarios are estimated to be 0.15, 0.40, and 0.45, respectively. Find the best expected value decision.

Q: For Peter Cartman’s investment decision, suppose that the probabilities of the

For Peter Cartman’s investment decision, suppose that the probabilities of the scenarios are estimated to be 0.35, 0.25, and 0.40, respectively. Find the best expected value decision.

Q: For the DoorCo Corporation decision, construct a decision tree and compute

For the DoorCo Corporation decision, construct a decision tree and compute the rollback values to find the best expected value decision.

Q: For Peter Cartman’s investment decision, construct a decision tree and compute

For Peter Cartman’s investment decision, construct a decision tree and compute the rollback values to find the best expected value decision.

Q: David Lee is a soft drinks stallholder at Cotton Tree Park.

David Lee is a soft drinks stallholder at Cotton Tree Park. He must decide how many soft drink cartons to order for the coming season. Each bottle of soft drink costs $2.50 and is sold for $4.80. No i...

Q: Dean Kuroff started a business of rehabbing old homes. He recently

Dean Kuroff started a business of rehabbing old homes. He recently purchased a circa-1800 Victorian mansion and converted it into a three-family residence. Yesterday, one of his tenants complained tha...

Q: Modify the data in the Base Data worksheet in the Excel file

Modify the data in the Base Data worksheet in the Excel file Credit Risk Data using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is...

Q: Many automobile dealers advertise lease options for new cars. Suppose that

Many automobile dealers advertise lease options for new cars. Suppose that you are considering three alternatives: 1. Purchase a car outright with cash. 2. Purchase a car with 20% down and a 48-month...

Q: Perform a sensitivity analysis of David Lee’s soft drinks stall scenario.

Perform a sensitivity analysis of David Lee’s soft drinks stall scenario. Find the optimal order quantity and optimal expected profit for probabilities of a cold weather ranging from 0.2 to 0.8 in inc...

Q: IM Retail deals in various products from a popular cosmetic brand Beau

IM Retail deals in various products from a popular cosmetic brand Beau. The cost of stocking and selling a product varies according to whether it is in season or not. In season, the cost of a product...

Q: For the payoff table you developed in Problem 1, determine the

For the payoff table you developed in Problem 1, determine the decision using the aggressive, conservative and opportunity-loss strategies. Data from Problem 1: Use the Outsourcing Decision Model Exc...

Q: Ravex Yacht has developed a new cabin cruiser, which they have

Ravex Yacht has developed a new cabin cruiser, which they have earmarked for the medium to large boat market. A market analysis suggests a 30% probability of annual sales being 5,000 boats, 40% probab...

Q: Drilling decisions by oil and gas operators involve intensive capital expenditures made

Drilling decisions by oil and gas operators involve intensive capital expenditures made in an environment characterized by limited information and high risk. A well site is dry, wet, or gushing. Histo...

Q: MetaGo is a small metal parts manufacturer. It has two automatic

MetaGo is a small metal parts manufacturer. It has two automatic machines (Machine A and Machine B) for daily production processes. Both the machines can produce defective metal parts. Historically, t...

Q: Consider Peter Cartman’s investment decision scenario. Use the approach described in

Consider Peter Cartman’s investment decision scenario. Use the approach described in this chapter to develop your personal utility function for the payoffs associated with this decision. Determine the...

Q: A college football team is trailing 14–0 late in the

A college football team is trailing 14–0 late in the game. The team just made a touchdown. If they can hold the opponent and score one more time, they can tie or win the game. The coach is wondering w...

Q: The DoorCo Corporation is a leading manufacturer of garage doors. All

The DoorCo Corporation is a leading manufacturer of garage doors. All doors are manufactured in their plant in Carmel, Indiana, and shipped to distribution centers or major customers. DoorCo recently...

Q: The Excel file Airbnb Samples provides 15 sample room rates for five

The Excel file Airbnb Samples provides 15 sample room rates for five randomly selected Airbnb accommodations. Define range names for each of the samples and then use these range names in formulas to f...

Q: Suppose that Peter Cartman is deciding whether to invest in a bond

Suppose that Peter Cartman is deciding whether to invest in a bond mutual fund or a stock fund. Both bond and stock funds are sensitive to changing market conditions. His analysis reveals that when th...

Q: As the marketing manager of a major perfume company, you are

As the marketing manager of a major perfume company, you are considering using either one of two ingredients, Neroli oil or Orris root, in the newest perfume to be launched by the company. The cost to...

Q: For the DoorCo Corporation decision, compute the standard deviation of the

For the DoorCo Corporation decision, compute the standard deviation of the payoffs for each decision. What does this tell you about the risk in making the decision?

Q: For Peter Cartman’s decision, compute the standard deviation of the payoffs

For Peter Cartman’s decision, compute the standard deviation of the payoffs for each decision. What does this tell you about the risk in making the decision?

Q: For the perfume company decision, compute the standard deviation of the

For the perfume company decision, compute the standard deviation of the payoffs for each decision. What does this tell you about the risk in making the decision?

Q: What decisions should be made using the average payoff strategy?

What decisions should be made using the average payoff strategy?

Q: Return on investment (ROI) is profit divided by investment.

Return on investment (ROI) is profit divided by investment. In marketing, ROI is determined as incremental sales times gross margin minus marketing investment, all divided by marketing investment. Sup...

Q: In the Accounting Professionals database, use Excel functions to find

In the Accounting Professionals database, use Excel functions to find a. the maximum number of years of service. b. the average number of years of service. c. the number of male employees in the datab...

Q: A company forecasts its net revenue for the next three years as

A company forecasts its net revenue for the next three years as $172,800, $213,580, and $293,985. Find the net present value of these cash flows, assuming a discount rate of 4.2%.

Q: Use the Histogram chart to construct histograms for weekly usage and waiting

Use the Histogram chart to construct histograms for weekly usage and waiting time in the Excel file Car Sharing Survey.

Q: Elizabeth Burke has received several questions from other PLE managers regarding quality

Elizabeth Burke has received several questions from other PLE managers regarding quality, customer satisfaction, and operational performance. She would like you to summarize some data from the Perform...

Q: Figure 2.41 shows the 2016 U.S. federal

Figure 2.41 shows the 2016 U.S. federal income tax rates for the four different types of filing status. Suppose an individual is single. Write one logical IF function that will determine the correct t...

Q: For the Base Data in the Excel file Credit Risk Data,

For the Base Data in the Excel file Credit Risk Data, use the Histogram chart to develop a histogram with a bin width of 5 for the number of months as a customer of the bank.

Q: Create box-and-whisker charts for each type of cost

Create box-and-whisker charts for each type of cost of living adjustment in the Excel file Cost of Living Adjustments.

Q: Define range names for all the data and model entities in the

Define range names for all the data and model entities in the Break-Even Decision Model spreadsheet and apply them to the formulas in the model.

Q: Define range names for all the entities in the Crebo Manufacturing Model

Define range names for all the entities in the Crebo Manufacturing Model spreadsheet and apply them to the formulas in the model.

Q: Define range names for all the entities in the Hotel Overbooking Model

Define range names for all the entities in the Hotel Overbooking Model spreadsheet and apply them to the formulas in the model.

Q: Discuss the use of business analytics in sports, such as tennis

Discuss the use of business analytics in sports, such as tennis, cricket, swimming, and football. Identify as many opportunities as you can for each.

Q: A tablet manufacturer is preparing to set the price of a new

A tablet manufacturer is preparing to set the price of a new model. It examines the demand and cost structure, and determines the following model to represent the relationship between demand and price...

Q: In this chapter, we noted the importance of defining and analyzing

In this chapter, we noted the importance of defining and analyzing a problem prior to attempting to find a solution. Consider this example: One of the earliest operations research groups during World...

Q: A part-time professor of a business program at a university

A part-time professor of a business program at a university in Germany always tells her students that one of the first questions they should ask their new employers is whether the organization has a g...

Q: How might analytics be used in the following situations? a

How might analytics be used in the following situations? a. Planning a business b. Understanding customer behavior c. Solving human resource problems

Q: For the Cereal database, write a logical IF function that enters

For the Cereal database, write a logical IF function that enters “Review” in column M if the rating is more than 45 and the sales is less than 150; if not, then enter a blank.

Q: Swissotel, London, is working on improving customer satisfaction and engagement

Swissotel, London, is working on improving customer satisfaction and engagement. At the same time, Swissotel wants to ensure that the staff members are also satisfied. It has noticed that there are se...

Q: Develop a spreadsheet for computing the demand for any values of the

Develop a spreadsheet for computing the demand for any values of the input variables in the linear demand and nonlinear demand.

Q: Construct histograms using the Histogram chart for the gross sales and gross

Construct histograms using the Histogram chart for the gross sales and gross profit data in the Excel file Sales Data.

Q: A new graduate has taken a job with an annual salary of

A new graduate has taken a job with an annual salary of $60,000. She expects her salary to go up by 2.5% each year for the first five years. Her starting salary is stored in cell A4 of an Excel worksh...

Q: Create box-and-whisker charts for each type of expense

Create box-and-whisker charts for each type of expense in the Excel file Budget Forecasting.

Q: A survey was conducted to identify the type of movies watched by

A survey was conducted to identify the type of movies watched by 15 people in the past two weeks. If the type of movie watched by one person is different from the others, then the code 1 will be assig...

Q: A shirt manufacturer needs to supply invoices to customers based on data

A shirt manufacturer needs to supply invoices to customers based on data from the Shirt Production Excel file, which indicates the costs (in £) and sizes. Modify the file to use the VLOOKUP function t...

Q: The Excel file S&P 500 provides open, high,

The Excel file S&P 500 provides open, high, low, and close values for the S&P 500 index over a period of time. a. Enter any date (using the format month/day/year) within the range of the data in cell...

Q: The Financial Forecasts database shows estimated variable and fixed expenses of a

The Financial Forecasts database shows estimated variable and fixed expenses of a firm for the first nine months of the coming year. Define range names for each month and the type of expense. Then use...

Q: Convert the Hospital Claim database to an Excel table. Use the

Convert the Hospital Claim database to an Excel table. Use the techniques to find: a. the total number of claims. b. the total number of outpatient claims. c. the total number of claims in January.

Q: Convert the Order Specifications database to an Excel table. Use the

Convert the Order Specifications database to an Excel table. Use the techniques to find: a. the total cost of all orders. b. the total cost of all orders placed with Multipurpose Fasteners. c. the to...

Q: The Excel file Stationary provides the sales data for a stationary company

The Excel file Stationary provides the sales data for a stationary company, and each row represents an order for its products. Convert these data into an Excel table and filter the central region for...

Q: The Excel file Global Industry Default and Rating summarizes financial information for

The Excel file Global Industry Default and Rating summarizes financial information for 32 European firms, in the manufacturing and services industries, and their perceived risk of default. Convert the...

Q: PLE collects a variety of data from special studies, many of

PLE collects a variety of data from special studies, many of which are related to the quality of its products. The company collects data about functional test performance of its mowers after assembly;...

Q: In the Excel file Automobile Quality Ranking, search for and add

In the Excel file Automobile Quality Ranking, search for and add a new column for the country of origin for each brand. Then sort the data from the lowest to highest by number of problems per 100 vehi...

Q: Create clustered column and stacked column charts for the pre-MBA

Create clustered column and stacked column charts for the pre-MBA and post-MBA salary data in the Excel file MBA Motivation and Salary Expectations. Discuss which type of chart you feel is better to u...

Q: The Excel file Transportation provides sales data about 10 different industries.

The Excel file Transportation provides sales data about 10 different industries. Construct two stacked bar charts that will allow you to compare any differences due to time or age groups and draw any...

Q: Construct an appropriate chart to show the sales per unit for the

Construct an appropriate chart to show the sales per unit for the primary industry in the Excel file Primary Industry.

Q: Construct an appropriate chart or charts to visualize the information in the

Construct an appropriate chart or charts to visualize the information in the Budget Forecasting Excel file. Explain why you chose the chart(s) you used.

Q: A survey was conduct for determine the number of vegetarians and non

A survey was conduct for determine the number of vegetarians and non-vegetarians between two different group of age of people. The survey results the followings: Convert the data into percentages for...

Q: Create a useful dashboard for the data in the Excel file President’s

Create a useful dashboard for the data in the Excel file President’s Inn Guest Database. Use the additional information stated in Problem 20 of Chapter 2: Room rates are the same for one or two guests...

Q: Create a useful dashboard for the data in the Excel file Restaurant

Create a useful dashboard for the data in the Excel file Restaurant Sales. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explain why you chose t...

Q: Create a line chart illustrating the number of AM and PM travelers

Create a line chart illustrating the number of AM and PM travelers for each month in the Excel file Traveler.

Q: Create a useful dashboard for the data in the Excel file Store

Create a useful dashboard for the data in the Excel file Store and Regional Sales Database. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explai...

Q: The worksheet Purchasing Survey in the Performance Lawn Care Database provides data

The worksheet Purchasing Survey in the Performance Lawn Care Database provides data related to predicting the level of business (Usage Level) obtained from a third-party survey of purchasing managers...

Q: Create a useful dashboard for the data in the Excel file Employees

Create a useful dashboard for the data in the Excel file Employees. Use appropriate charts, layouts, and other visualization tools that help to convey the information. Explain why you chose the elemen...

Q: Create a pie chart for all the given dates and a stock

Create a pie chart for all the given dates and a stock chart for the high/low/close prices for March 2018 in the Stock Excel file.

Q: The Excel file Expenditure contains data on a country’s expenditure on various

The Excel file Expenditure contains data on a country’s expenditure on various sports during a particular year. Create a pie chart showing the percentage breakdown of total expenditure.

Q: Create a stacked area chart for the monthly average sales of the

Create a stacked area chart for the monthly average sales of the different types of fuel in the Excel file Average Fuel Sales. What conclusion can you reach?

Q: The Excel file Mortgage Installment provides the monthly installment of a mortgage

The Excel file Mortgage Installment provides the monthly installment of a mortgage loan by different fixed interest rate (%) provided by different banks. Construct a scatter diagram to show the relati...

Q: The Excel file Monthly Visits provides the data for monthly visitors visited

The Excel file Monthly Visits provides the data for monthly visitors visited a playground and the number of shows prepared by the playground organizer during the specific month. Create a scatter diagr...

Q: Construct a column chart for the data in the Excel file Purchasing

Construct a column chart for the data in the Excel file Purchasing Rate to allow comparison of the rate for each product with the date. Would any other charts be better for visually conveying this inf...

Q: A survey handed out to students at a local university in Munich

A survey handed out to students at a local university in Munich, Germany, asked the following: ■ Where do you live? (1- On Campus 2- City 3- Other) ■ How do you feel today? (using a scale of 1–5, ran...

Q: Identify the bins for number of letters, width, and height

Identify the bins for number of letters, width, and height in the provided data in the Excel file Letter. Then use the Histogram tool to compute frequency distributions and cumulative relative frequen...

Q: Use a PivotTable to construct a frequency distribution and histogram of lunch

Use a PivotTable to construct a frequency distribution and histogram of lunch sales amounts in the Restaurant Sales database.

Q: Part 1: The Performance Lawn Equipment Database contains data needed to

Part 1: The Performance Lawn Equipment Database contains data needed to develop a pro forma income statement. Dealers selling PLE products all receive 18% of sales revenue for their part of doing busi...

Q: Use a PivotTable to develop a frequency distribution with six bins for

Use a PivotTable to develop a frequency distribution with six bins for the age of individuals in the Base Data worksheet in the Credit Risk Data file. Compute and chart the relative and cumulative rel...

Q: Use a PivotTable to construct a frequency distribution and histogram for GPA

Use a PivotTable to construct a frequency distribution and histogram for GPA in the Excel file Grade Point Averages.

Q: Find the 25th and 70th percentiles of the costs in the Excel

Find the 25th and 70th percentiles of the costs in the Excel file Road Construction. Use formula (4.3), the Excel PERCENTILE.INC function, and the Rank and Percentile tool, and compare the results.

Q: Find the first, second, and third quartiles for the combined

Find the first, second, and third quartiles for the combined amounts of checking and savings accounts in the Excel file Credit Risk Data and interpret the results.

Q: Find the first, second, and third quartiles for the sales

Find the first, second, and third quartiles for the sales amounts in the Sales Transactions database and interpret the results.

Q: Use PivotTables to construct cross-tabulations for (1) neighborhood

Use PivotTables to construct cross-tabulations for (1) neighborhood and improvement and (2) neighborhood and structure home for the Excel file Home.

Q: Use PivotTables to construct cross-tabulations between each pair of variables

Use PivotTables to construct cross-tabulations between each pair of variables in the Excel file Beverage Preferences

Q: Find the mean, median, and midrange for the data in

Find the mean, median, and midrange for the data in the Excel file Automobile Quality using the appropriate Excel functions or formulas.

Q: Compute the mean, median, midrange, and mode for each

Compute the mean, median, midrange, and mode for each of the importance factors in the Excel file Coffee Shop Preferences using the appropriate Excel functions.

Q: Considering the data in the Excel file House Market Value as a

Considering the data in the Excel file House Market Value as a population of homeowners on this street, compute the mean, variance, and standard deviation for each of the variables using a spreadsheet...

Q: In one of PLE’s manufacturing facilities, a drill press that has

In one of PLE’s manufacturing facilities, a drill press that has three drill bits is used to fabricate metal parts. Drill bits break occasionally and need to be replaced. The present policy is to repl...

Q: Use the Excel file Course Marks to calculate the mean, variance

Use the Excel file Course Marks to calculate the mean, variance and standard deviation for each variable using formulas (4.5), (4.8), and (4.10). Verify your calculations using the appropriate Excel f...

Q: In the Excel file Facebook Survey, find the range, variance

In the Excel file Facebook Survey, find the range, variance, standard deviation, and interquartile range for hours online/week and number of friends in the sample using the appropriate Excel functions...

Q: Use the Descriptive Statistics tool to summarize the mean, median,

Use the Descriptive Statistics tool to summarize the mean, median, variance, and standard deviation of the prices of shares in the Coffee Shares Excel file.

Q: Use the Excel file Land to find the mean, standard deviation

Use the Excel file Land to find the mean, standard deviation, and interquartile range of the land size. Show that Chebyshev’s theorem holds for the data and determine how accurate the empirical rules...

Q: The Excel file Atlanta Airline Data provides arrival and taxi-in

The Excel file Atlanta Airline Data provides arrival and taxi-in time statistics for one day at Atlanta Hartsfield International Airport. Find the mean and standard deviation of the difference between...

Q: Compute the mean and standard deviation of the data in the Cost

Compute the mean and standard deviation of the data in the Cost of Living Adjustments Excel file. Then compute the z-scores for the comparative salaries and housing adjustments and interpret your resu...

Q: Compute the coefficient of variation for each variable in the Excel file

Compute the coefficient of variation for each variable in the Excel file Course Marks. Which has the least and greatest relative dispersion?

Q: Find 30 days of stock prices for three companies in different industries

Find 30 days of stock prices for three companies in different industries. The average stock prices should have a wide range of values. Using the data, compute and interpret the coefficient of variatio...

Q: Apply the Descriptive Statistics tool for subsets of liberal arts colleges and

Apply the Descriptive Statistics tool for subsets of liberal arts colleges and research universities in the Excel file Colleges and Universities. Compare the two types of colleges. What can you conclu...

Q: Use the Descriptive Statistics tool to summarize the responses in the Excel

Use the Descriptive Statistics tool to summarize the responses in the Excel file Job Satisfaction. What information can you conclude from this analysis?