New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
business analytics data
Business Analytics 2nd Edn 2nd Edition James Evans - Solutions
11. The State of Ohio Department of Education has a mandated ninth-grade proficiency test that covers writing, reading, mathematics, citizenship (social studies), and science. The Excel file Ohio Education Performance provides data on success rates (defined as the percent of students passing) in
10. A sample of 400 athletes is found to have mean height of 171.38 cm. Can we call it a sample from a large popu- lation of mean height 171.17 and standard deviation of 3.30 cm?
9. The manager of a store claims that 60% of the shoppers entering the store leave without making a purchase. Out of a sample of 50, it is found that 35 shoppers left with- out buying. Is the result consistent with the claim?
8. Call centers typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank's call centers in the Excel file Call Center Data. In writing an article about call center working conditions, a reporter has claimed that
7. Ice Cream Manufacture is to produce a new ice cream flavor. The company's marketing research de- partment surveyed 6,000 families and 335 of them showed interest in purchasing the new flavor. A simi- lar study made two year ago showed that 5% of the families would purchase the flavor. What
6. Metropolitan Press hypothesizes that the average life of its largest Web press is 14,500 hours. They know that the standard deviation of press life is 2,100 hours. From a sample of 25 presses, the company find sample mean of 13,000 hours. At a 0.01 significance level, should the company conclude
5. A financial advisor believes that the proportion of in- vestors who are risk-averse (i.e., try to avoid risk in their investment decisions) is at least 0.7. A survey of 32 investors found that 20 of them were risk-averse.
4. A retailer believes that its new advertising strategy will increase sales. Previously, the mean spending in 15 categories of consumer items in both the 18-34 and 35+ age groups was $70.00.
3. A management institute checked the past records of ap- plicants and the mean score calculated was 350. The administration is interested to know whether the quality of new applicants has changed or not. From the recent scores of 100 applicants, the mean is 365 with a standard deviation of 38.
2. A company is considering two different campaigns, A and B, for the promotion of their product. Two tests are conducted in two market areas with identi- cal consumer characteristics, and in a random sample of 60 customers who saw campaign A, 18 tried the product. In a random sample of 100
1. Create an Excel workbook with worksheet templates (similar to the Excel workbook Confidence Intervals) for one-sample hypothesis tests for means and propor- tions. Apply your templates to the example problems in this chapter. (For subsequent problems, you should use the formulas in this chapter
6. How many blade weights must be measured to find a 95% confidence interval for the mean blade weight with a sampling error of at most 0.2? What if the sampling error is specified as 0.1?
5. For the data in the worksheet Blade Weight, what is the sampling distribution of the mean, the overall mean, and the standard error of the mean? Is a normal distribution an appropriate assumption for the sampling distribution of the mean?
4. What would be a confidence interval for an additional sample of mower test performance as in the worksheet Mower Test?
3. Engineering has collected data on alternative process costs for building transmissions in the worksheet Transmission Costs. Can you determine whether one of the proposed processes is better than the current process?
2. What estimates, with reasonable assurance, can PLE give customers for response times to customer service calls?
1. What proportion of customers rate the company with“top box” survey responses (which is defined as scale levels 4 and 5) on quality, ease of use, price, and service in the 2012 Customer Survey worksheet? How do these proportions differ by geographic region?
29. A music company wants to know how the illegal downloading of music online affects CD sales. 600 families are randomly chosen from various parts of a particular country and the number of songs that are downloaded in an hour are noted. The sample mean is 3947 with a sample standard deviation of
28. After regular complaints of tire blowouts on the Ya- muna Expressway, in an automotive test conducted by the authorities, the average tire pressure in a sam- ple of 62 tires was found to be 24 pounds per square inch and the standard deviation was 2.1 pound per square inch.
27. If a manufacturer conducted a survey among ran- domly selected target market households and wanted to be 95% confident that the difference between the sample estimate and the actual market share for its new product was no more than 2%, what sample size would be needed?
26. Trade associations, such as the United Dairy Farmers Association, frequently conduct surveys to identify characteristics of their membership. If this organiza- tion conducted a survey to estimate the annual per- capita consumption of milk and wanted to be 95% confident that the estimate was no
24. The Excel file Restaurant Sales provides sample in- formation on lunch, dinner, and delivery sales for a local Italian restaurant. Develop 95% prediction inter- vals for the daily dollar sales of each of these variables and also for the total sales dollars on a weekend day. 25. For the Excel
23. Using the data in the worksheet Consumer Trans- portation Survey, develop 95% and 99% prediction intervals for the following:a. the hours per week that an individual will spend in his or her vehicleb. the number of miles driven per week?
22. A study of nonfatal occupational injuries in the United States found that about 31% of all injuries in the service sector involved the back. The Na- tional Institute for Occupational Safety and Health (NIOSH) recommended conducting a comprehensive ergonomics assessment of jobs and workstations.
21. 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 is within 1.4 (18 times out of 20).a. What percent of confidence level is the result?b. What is the margin of
20. The Excel file Baseball Attendance shows the at- tendance in thousands at San Francisco Giants" baseball games for the 10 years before the Oakland A's moved to the Bay Area in 1968, as well as the combined attendance for both teams for the next 11 years. Develop 95% confidence intervals for the
19. Using data in the Excel file Colleges and Universi- ties, find 95% confidence intervals for the median SAT for each of the two groups, liberal arts colleges and research universities. Based on these confidence intervals, does there appear to be a difference in the median SAT scores between the
18. The monthly sales of a mobile phone shop have been distributed with a standard deviation of $900. A statistical study of sales in the last nine months has found a confidence interval for the mean of monthly sales with extremes of $5663 and $6839.a. What were the average sales over the nine
17. Using the data in the worksheet Consumer Transpor- tation Survey, develop 95% confidence intervals for the following: the proportion of individuals who are satisfied with their vehicleb. the proportion of individuals who have at least one child
16. The Excel file Restaurant Sales provides sample information on lunch, dinner, and delivery sales for a local Italian restaurant. Develop 95% confidence intervals for the mean of each of these variables, as well as total sales for weekdays and weekends. What conclusions can you reach?
15. Find the standard deviation of the total assets held by the bank in the Excel file Credit Risk Data.a. Treating the records in the database as a popula- tion, use your sample in Problem 2 and compute?
14. Using the data in the Excel file Accounting Profes- sionals, find and interpret 95% confidence intervals for the following:a. mean years of serviceb. proportion of employees who have a graduate degree
13. If, based on a sample size of 200, a political candi- date found that 125 people would vote for her in a two-person race, what is the 99% confidence interval for her expected proportion of the vote? Would she be confident of winning based on this poll?
12. If, based on a sample size of 850, a political candidate finds that 458 people would vote for him in a two- person race, what is the 95% confidence interval for his expected proportion of the vote? Would he be confident of winning based on this poll? Use the ap- propriate formula and verify
11. A bank sampled its customers to determine the proportion of customers who use their debit card at least once each month. A sample of 50 cus- tomers found that only 12 use their debit card monthly. Find 95% and 99% confidence intervals for the proportion of customers who use their debit card
10. A sample of 25 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 num- ber of restaurant visits. Use the appropriate formula and verify your result using the
9. A sample of 20 international students attending an urban U.S. university found that the average amount budgeted for expenses per month was $1612.50 with a standard deviation of $1179.64. Find a 95% confi- dence interval for the mean monthly expense budget of the population of international
8. A sample of 33 airline passengers found that the average check-in time is 2.167. Based on long-term data, the population standard deviation is known to be 0.48. Find a 95% confidence interval for the mean check-in time. Use the appropriate formula and verify your result using the Confidence
7. A soft drink bottle filling machine is known to have a mean of 200 ml and a standard variation of 10 ml. The quality control manager took a random sample of the filled bottles and found the sample mean to be 215 ml. She assumed the sample must not be repre- sentative. Do you agree with the
6. Uncle's Pizza is doing good business in Delhi due to its prompt home delivery system. It guarantees that the pizza will be delivered within 30 minutes from the time order was placed or the order is free. The time that it takes to deliver each order on time is maintained in the Pizza Time System.
10. Was the assumption that blade weights are normally distributed justified? What is the best-fitting prob- ability distribution for the data?
9. Could any of the blade weights be considered outli- ers, which might indicate a problem with the manu- facturing process or materials?
8. Is the process that makes the blades stable over time? That is, are there any apparent changes in the pattern of the blade weights?
7. What is the actual percent of weights that exceed 5.20 or are less than 4.80 from the data in the worksheet?
6. What is the probability that weights will be less than 4.80?
5. Assuming that the data are normal, what is the prob- ability that blade weights from this process will ex- ceed 5.20?
4. What is the average blade weight and how much variability is occurring in the measurements of blade weights?
3. What is the probability of having x failures in the next 100 mowers tested, for x from 0 to 20?
2. What fraction of mowers fails the functional perfor- mance test using all the mower test data?
1. For the mower test data, what distribution might be ap- propriate to model the failure of an individual mower?
50. Use Analytic Solver Platform to fit a distribution to the data in the Excel file Computer Repair Times.
48. A government agency is putting a large project out for low bid. Bids are expected from 10 different contractors and will have a normal distribution with a mean of $3.5 million and a standard deviation of $0.25 million. Devise and implement a sampling?
44. Develop a procedure to sample from the probability distribution of two-card hands in Problem 2. Implement your procedure on a spreadsheet and use the VLOOKUP function to sample 20 outcomes from the distribution. 45. Use formula (5.23) to obtain a sample of 25 outcomes for a game of BattleshipTM
36. In determining automobile-mileage ratings, it was found that the mpg (X) for a certain model is nor- mally distributed, with a mean of 33 mpg and a stan- dard deviation of 1.7 mpg. Find the following: P(X
33. Verify that the function corresponding to the fol- lowing figure is a valid probability density function. Then find the following probabilities:a. P(x < 8)b. P(x > 7)c. P(6 < x < 10)d. P(8
32. The number and frequency of Atlantic hurricanes an- nually from 1940 through 2012 is shown here.
30. A telephone call center where people place market- ing calls to customers has a probability of success of 0.08. The manager is very harsh on those who do not get a sufficient number of successful calls. Find the number of calls needed to ensure that there is a prob- ability of 0.90 of obtaining
23. The Excel sheet Baseball contains information about a team which is using an automatic pitching ma- chine. If the machine is correctly setup and properly adjusted, it will strike 85 percent of the time. If it is incorrectly set up, it will strike only 35 percent of the time. Past data indicates
18. A political candidate running for local office is con- sidering the votes she can get in an upcoming election. Assume that the votes can take on only four possible values. If the candidate assessment is per the given Excel sheet Votes, construct the probability distribu- tion graph.
14. In an example in Chapter 3, we developed the following cross-tabulation of sales transaction data: Region Book DVD Total East 56 42 98 North 43 42 85 South 62 37 99 West 100 90 190 Total 261 211 472
12. A survey of shopping habits found the percentage of respondents that use technology for shopping as shown in Figure 5.37. For example, 17.39% only use online coupons; 21.74% use online coupons and check prices online before shopping, and so on.a. What is the probability that a shopper will
11. Row 26 of the Excel file Census Education Data gives the number of employed persons having a spe- cific educational level.a. Find the probability that an employed person has attained each of the educational levels listed in the data.b. Suppose that A is the event "has at least an As- sociate's
7. Roulette is played at a table similar to the one in Fig- ure 5.36. A wheel with the numbers 1 through 36 (evenly distributed with the colors red and black) and two green numbers 0 and 00 rotates in a shallow bowl with a curved wall. A small ball is spun on the inside of the wall and drops into a
4. The students of a class have elected five candi- dates to represent them on the college management council: S.No. Gender Age 12345 Male 18 Male 19 Female 22 Female 20 Male 23
2. Consider the experiment of drawing two cards without replacement from a deck consisting of only the ace through 10 of a single suit (e.g., only hearts).a. Describe the outcomes of this experiment. List the elements of the sample space.b. Define the event A, to be the set of outcomes for which
A producer of computer-aided design software for the aerospace industry receives numerous calls for technical support. Tracking software is used to moni- tor response and resolution times. In addition, the company surveys customers who request support us- ing the following scale: (A-545)
In the Excel file Weddings, find the averages and median wedding cost and the sample standard devia- tion. What would you tell a newly engaged couple about what cost to expect? Consider the effect of possible outliers in the data. (A-545)
Examine the z-scores you computed in Problem 4 for the Atlanta Airline Data. Do they suggest any outli- ers in the data? (A-545)
Find the mean and variance of a deck of 52 cards, where an ace is counted as 11 and a picture card as 10. Construct a frequency distribution and histogram of the card values. Shuffle the deck and deal two? (A-545)
Compute the z-scores for the data in the Excel file Air port Service Times. How many observations fall farther than three standard deviations from the mean? Would you consider these as outliers? Why or why not? (A-545)
In the Excel file Call Center Data, how strongly is length of service correlated with starting age? (A-545)
The Excel file Beverage Sales lists a sample of weekday sales at a convenience store, along with the daily high temperature. Compute the covariance and correlation between temperature and sales. (A-545)
For the Excel file Test Scores and Sales made by nine salesmen during the past year, compute the co- efficient of correlation between the test scores and sales using Excel's CORREL function. (A-545)
For the data in the Excel file Rin's Gym, find the co- variances and correlations among height, weight, and BMI calculation. (A-545)
In the Excel file Weddings, determine the correlation between the wedding costs and attendance. (A-545)
Using PivotTables, compute the mean and standard deviation for each metric by year in the Excel file Freshman College Data. Are any differences appar- ent from year to year? (A-545)
For the Excel file Travel Expenses, use a PivotTable to find the average and standard deviation of ex- penses for each sales rep. (A-545)
Using PivotTables, find the average and standard deviation of sales in the Sales Transactions database. (A-545)
In the Excel file Cell Phone Survey, use PivotTables to find the average for each of the numerical variables for different cell phone carriers and gender of respondents. (A-545)
In the Excel file Facebook Survey, use a PivotTable to find the average and standard deviation of hours online/week and number of friends for females and males in the sample (A-545)
In the Excel file Economic Poll, find the proportions of each categorical variable. (A-545)
In the Sales Transactions database, find the proportion of customers who used PayPal and the proportion of customers who used credit cards. Also, find the propor- tion that purchased a book and the proportion that pur- chased a DVD. (A-545)
In the Excel file Bicycle Inventory, find the propor- tion of bicycle models that sell for less than $200. (A-545)
Consider the Excel file Mobiles Usage, which shows the number of people using different kinds of mobile phones in the northern region. Find the proportion of BlackBerry and Android usage in that region. (A-545)
The average monthly wages and standard deviations for the two garments manufacturing factories X and Yare given below: (A-545)
Use the Descriptive Statistics tool to summarize the mean, median, variance, and standard deviation of the prices of shares in the Excel file Coffee Shares Data. (A-545)
Compute descriptive statistics for liberal arts col- leges and research universities in the Excel file Col- leges and Universities. Compare the two types of colleges. What can you conclude? (A-545)
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 variation. (A-545)
Data obtained from a county auditor in the Excel file Home Market Value provides information about the age, square footage, and current market value of houses along one street in a particular subdivision. (A-545)
For the Excel file Tablet Computer Sales, find the average number, standard deviation, and inter- quartile range of units sold per week. Show that Chebyshev's theorem holds for the data and deter- mine how accurate the empirical rules are. (A-545)
In the Excel file Facebook Survey, find the average and median hours online/week and number of friends in the sample using the appropriate Excel functions. Compute the midrange and compare all measures of location. (A-545)
The Excel File Rin's Gym provides sample data on member body characteristics and gym activity. Cre- ate PivotTables to find:a. a cross-tabulation of gender and body type versus BMI classificationb. average running times, run distance, weight lift- ing days, lifting session times, and time spent in
Create a PivotTable for the data in the Excel file Weddings to analyze the wedding cost by type of payor and value rating. What conclusions do you reach? (p. 18)
Use PivotTables to find the number of loans by dif- ferent purposes, marital status, and credit risk in the Excel file Credit Risk Data. Illustrate the results on a PivotChart. (p. 18)
Use Pivot Tables to construct a cross-tabulation for marital status and housing type in the Excel file Credit Risk Data. Illustrate the results on a PivotChart. (p. 18)
Construct cross-tabulations of Gender versus Car- rier and Type versus Usage in the Excel file Cell Phone Survey. What might you conclude from this analysis? (p. 18)
Find the 10th and 90th percentiles and 1st, 2nd, and 3rd quartiles for the combined amounts of checking and savings accounts in the Excel file Credit Risk Data. (p. 18)
Find the 20th and 80th percentiles of home prices in the Excel file Home Market Value. (p. 18)
A community health-status survey obtained the following demographic information from the respondents: (p. 18)
Use the Histogram tool to construct a frequency dis- tribution of lunch sales amounts in the Restaurant Sales database. (p. 18)
Showing 1000 - 1100
of 4107
First
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Last
Step by Step Answers
Get 50% OFF
Claim Now
