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

Result Not Found

Books FREE
Study Help
Tutors
AI Study Planner NEW
Sell Books

Search
Sign In
Register

study help
mathematics
statistics

Analyzing Data And Making Decisions Statistics For Business Microsoft Excel 2010 Updated 2nd Edition Judith Skuce - Solutions

The manager of an upscale coffee store is trying to decide which of three locations would be best for a new store. The manager currently wants to determine whether there are differences in the foot traffic at each location. The manager hires three students, and has them count the number of
The owner of a winery is wondering whether the average purchase of visitors to her winery differs according to age. She asks the cashiers to keep track of a random sample of purchases by customers in three age groups: under 30, 30-50, over 50. Because there is no good reason to ask a customer his
A college wants to compare the annual salaries of graduates of the four different streams of its business diploma program, five years after graduation. The college randomly selects graduates from each of the streams (marketing, accounting, human resources, general business) and, with appropriate
A commuter is trying to figure out the fastest way to drive to work in the morning. She keeps track of the times (in minutes) for three different routes on a random sample of mornings. Her records are shown in Exhibit 11.20.Is there evidence, at the 5% significance level, of a difference in
Does the type of safety training affect the number of factory accidents? Check to see that the conditions required for one-way ANOVA are met.
Does the type of safety training affect the number of factory accidents? Conduct a test of hypothesis at the 5% level of significance.
Does the type of safety training affect the number of factory accidents? Use the Tukey Kramer procedure (with 95% confidence intervals) to identify the worst training method(s).
A semi-retired economist is thinking about retiring fully, and he finds himself checking his mutual fund portfolio daily to see how his investments are doing. He notices that the time it takes to log on to his investment account online varies widely, and he wonders whether the connection times vary
A commuter is trying to decide whether there is a difference in the amount of time it takes him to drive to work, depending on departure time in the morning. He keeps track of the number of minutes his commute takes him, on a random sample of days, with three departure times: 6 A.M., 7 A.M., and 8
A professor who hates being scheduled for 8 A.M. classes, or classes on Friday afternoons after 3 P.M., has decided to investigate whether student grades are affected by the time at which classes take place. She keeps track of the grades of students who are scheduled for class at 8 A.M. on
The owner of a drugstore is wondering whether the amount of a customer's purchase varies by age group. The owner runs a contest with a grand prize of a $100 gift certificate that can be used in the store. The entry ballot requires the entrant to record his/her age group, and the amount of his/her
Refer to Exercise 16. Does it appear that the drugstore customers' purchases vary by age group-in other words, are the mean purchases of customers in the different age groups equal? Use a 5% level of significance.In exerciseThe owner of a drugstore is wondering whether the amount of a customer's
Refer to Exercise 16. Use the Tukey-Kramer procedure to identify which average purchases differ. Use a 95% level of confidence.In exerciseThe owner of a drugstore is wondering whether the amount of a customer's purchase varies by age group. The owner runs a contest with a grand prize of a $100 gift
Refer to Exercise 16. Do the data represent a random sample? Explain why or why not.In exerciseThe owner of a drugstore is wondering whether the amount of a customer's purchase varies by age group. The owner runs a contest with a grand prize of a $100 gift certificate that can be used in the store.
Statistics Canada provides "microdata, "based on census data for Canada. The microdata files contain representative samples of census data. You can access these data sets at the Statistics Canada website, www.statcan.ca/english/kits/microdata/2001Census/intropages.htm. The data sets are quite
There are many factors that affect a student’s success in school. A professor is concerned that many of her students work at part-time or even full-time jobs while they are attending school. Work responsibilities leave less time available for studying. The professor selects a random sample of her
Refer to Exhibit 11.27 above. Fill in the missing values.€¢ The average for each class€¢ The degrees of freedom (Between Groups, Within Groups, and Total)€¢ The mean squares€¢ The F statistic
Estimate the p-value of the F statistic that you calculated in Exercise 3. At the 5% level of significance, do the data on class marks suggest that there are differences in the average marks of the classes?
Use the Tukey-Kramer procedure to identify which class or classes the student who wants a high mark should avoid, and which class or classes the student should prefer. Use a 95% confidence level. Is this method of choosing classes valid? Why or why not?
A credit card company is trying to determine whether people who own different types of credit cards typically carry different balances, on average. A random sample of people with Visa, Mastercard, and American Express cards is selected. Cardholders are enticed into revealing the balance on their
Telemarketing Company is monitoring the performance of four newly hired employees. It is important that employees do not spend too much time on the phone with customers, particularly if the time spent does not result in a sale. A supervisor monitors a random sample of calls taken by each new
Estimate the p-value of the F statistic you calculated in Exercise 7.At the 5% level of significance, do the data on length of calls suggest that there are differences in the average number of minutes each employee spends with a customer before making a sale?
Use the Tukey-Kramer procedure to identify which employees spend less time, on average, with customers before making a sale. Use a 95% confidence level.
Airline mergers are sometimes followed by a decrease in performance, as operations are rationalized and staff adjusts to new operating protocols. One measure of airline efficiency is the percentage of on-time departures. Before a recent merger, Northeast Airlines took a random sample of 100
A financial services company conducted a survey of a random sample of its customers. One of the items on the survey was, "The staff at my local branch can provide me with good advice on my financial affairs." Customers responded as follows: 10 strongly agreed, 57 agreed, 32 neither agreed nor
A random sample of the employees of a large organization were surveyed about their views of a proposed change in the company's health benefits. The results of the survey are shown in Exhibit 12.32.Is there evidence, at the 1% level of significance, that there is a relationship between the views on
A company that sells sunscreen products wants to know whether there is a relationship between people's hair colour and their tendency to apply sunscreen before going outside. For example, it may be that redheads and blondes are more sensitive to the sun, and are therefore more likely to use
A newspaper was trying to determine whether there was a relationship between household income and the sections of the newspaper that were most closely read. A random survey of households revealed the results shown in Exhibit 12.34.At the 2.5% level of significance, is there evidence that income is
A random sample of 100 students was taken from four large schools in Montreal. The first language of the students was recorded. The results are shown in Exhibit 12.35 below. Is there evidence, at the 5% significance level, of a difference in the proportions of students whose first language is
The marketing department of a college wanted to know whether there was a difference in the proportions of students drawn from inside and outside the college catchment area by program. A random sample of students from each of the business, technology, and nursing programs revealed the results shown
In 2009, a study showed that the percentage of online Canadians with a social network profile had increased to 56%, up from 39% in a study done 18 months previously. In 2009, 824 online Canadians were surveyed (462 indicated they had a social network profile). In the previous study, 800 online
A major bank implemented a number of policies and procedures to try to ensure that its female employees have as much opportunity for advancement as its male employees. The bank decided to check employees' perceptions of opportunity for advancement. A random sample of 240 female employees
The marketing department is investigating methods of promoting the extended warranty for electronic equipment. In one method, customers are informed about the extended warranty by the cashier at the checkout. In another method, customers see a prominent display at the checkout. A random sample of
Create a 90% confidence interval estimate for the difference in the proportions of customers who bought the extended warranty for the two promotion methods described in Exercise 4 above. Do you expect this interval to include zero? Why or why not?
A furniture store has a number of payment options available to customers. Some customers pay immediately. Others delay payment for six months, with no interest and no financing charges. Others delay payment for a year, but with interest and financing charges. In the past, 26% of customers paid
A new manager has been hired to run the campus student pub. The pub sells a limited selection of brands of beer. The past manager indicated that the brand preferences of the pub's customers were as shown in Exhibit 12.17 below.The new manager wants to check on customer preferences so that he can
John is a small businessman who gets in over his head, incurring debts he cannot pay. In desperation, he turns to the local motorcycle gang to borrow some money to keep his business afloat. He hopes to solve his money problems at the local casino. At first he does well, winning regularly, and then
A travel agency collects data on the proportion of its customers who want to travel to popular destinations.Historically, the customer preferences have been as indicated in Exhibit 12.19.A random sample of 54 customers revealed that:€¢ 22 wanted to travel in Canada€¢ 14 wanted to travel to
Why would it be incorrect to pool the sample data to get an estimate of when the null hypothesis is p1 – p2 = 0.05?
Construct a 95% confidence interval estimate for the difference in proportions of students who send acceptances after receiving offers of admission, comparing those who receive phone calls from program faculty with those who receive only packages in the mail.
A quality control inspector wants to test that the proportion of defective items in three shipments of components from different manufacturers is equal. A random sample of 125 items is selected from each shipment. The first sample has 36 defective items, the second has 30, and the third has 38.
A company operates two large plants. In one plant, a random sample of 150 employees revealed that 23 had had workplace accidents during the past year. In the other plant, a random sample of 125 employees revealed that 23 had had workplace accidents during the past year. At the 5% level of
Re-do Exercise 14 above as a Chi-square test. Is the p-value the same for both tests? Did you expect it to be?In Exercise A company operates two large plants. In one plant, a random sample of 150 employees revealed that 23 had had workplace accidents during the past year. In the other plant, a
A large international company often gives its managers opportunities to work in foreign countries, and is interested to see if the willingness to accept a foreign posting is related to the family status of the individual being offered the opportunity. A random sample of 190 individuals who had been
A car parts plant is concerned that some of its employees are more likely to call in sick on Fridays or Mondays (the plant operates only five days a week).An analyst randomly selects one week, and records the number of absences each day. The data are shown below in Exhibit 12.38.Based on these
A random sample of people who regularly attend movies in St. John€™s is selected. Each is asked which of several types of movies is his or her favourite. The answers were categorized according to the gender of the survey respondent. The results are shown in Exhibit 12.39 below.Is there evidence
A random sample of 78 employees at a large computer software firm was polled to determine method of travel to work. A random sample of 80 employees of an accounting firm in the same office complex was also polled. The results are shown in Exhibit 12.40 below. Is there evidence that the proportions
Why don’t we pool sample data when we are constructing a confidence interval estimate of p1 – p2?
A restaurant is interested in whether there is difference in the tendency to drink beer, wine, and other alcoholic drinks, by gender. A survey of a random sample of customers who bought alcoholic beverages revealed the data shown in Exhibit 12.41.Is the distribution of preferences for beer, wine,
A quality control inspector is checking to see whether the proportions of different kinds of nuts included in a mixed-nuts package meet specifications. She randomly selects one of the bags of nuts off the line, and counts how many nuts of each type are included. The results are shown in Exhibit
The company that produces the mixed nuts described in Exercise 21 claims that the percentage of peanuts in the mixed-nuts package is no more than 50%. Does this sample provide evidence that there are more than 50% peanuts in the mixed nuts packages? Use Î± = 2.5%.In exercise
A randomly selected package from a competing company producing mixed nuts provides the information shown in Exhibit 12.43.Is there evidence of a difference in the proportion of types of nuts for the two companies? Use Î± = 5%.
24. Based on the sample evidence in Exhibits 12.42 and 12.43 in Exercises 21 and 23, is there evidence of a difference in the proportions of peanuts in the mixed-nuts packages of the two companies? Use Î± = 5%.
Construct a 90% confidence interval estimate of the difference in proportion of peanuts in the mixed-nuts packages described in the previous exercises. Do you expect this confidence interval to contain zero? Why or why not?
Suppose you wanted to investigate the proportion of different types of nuts in bags of mixed nuts. You are feeling too lazy to count the number of each type of nut, so you hit upon the idea of weighing the nuts by type. Will you be able to use the information on weights and the Chi-square test to
A student who is taking statistics for the second time (for the fun of it!) wants to compare the proportion of students who pass the course at his college using Analyzing Data and Making Decisions as their text, compared with last year, when a competitor text was used. The student believes the
Why is there no such thing as a left-tailed goodness-of-fit test?
A random sample of new members of a large downtown fitness club was selected, and tracked over six months. Of the 60 members who joined the club to participate in fitness classes, 38 were still working out regularly six months after joining. Of the 80 members who joined to work out with a personal
Re-do Exercise 6 above as a Chi-square test. Did you get the same answer? Did you expect to?In exercise A random sample of new members of a large downtown fitness club was selected, and tracked over six months. Of the 60 members who joined the club to participate in fitness classes, 38 were still
A large mail order company is trying to decide between two delivery services: Canada Post and a private courier. The mail order company selects a random sample of 100 deliveries for the private courier, and another sample of 75 for Canada Post. The proportion of deliveries that were on time or
Colleges work hard to convert offers of admission into acceptances. One college has been experimenting with phone calls from program faculty to prospective students to encourage students to accept offers of admission. In a random sample of 278 students who were called by program faculty, 234 sent
The Hendrick Software Sales Company has collected data on the number of contacts made by its sales staff, and the software sales, for a random sample of months. Create an appropriate scatter diagram for these data. What is the least-squares regression line? Interpret it.
Check that the requirements for the theoretical model are met for the data on the number of employees and revenues for the top 25 global research organizations. Are there any outliers? Are there any influential observations?
If appropriate, test to see whether there is evidence of a positive relationship between the number of sales contacts and sales for the Hendrick Software Sales Company. Use α = 0.05.
If appropriate, test to see whether there is evidence of a positive relationship between monthly income and monthly spending on restaurant meals for the data collected for households in Vancouver. Use α = 0.04.
If appropriate, test to see whether there is evidence of a negative relationship between semester average marks and hours spent working. Use α = 0.05.
Interpret the coefficient of determination for the data set from the Hendrick Software Sales Company. Given this number, can you conclude that the way to increase sales is to increase the number of sales contacts made by the staff?
The coefficient of determination for the data collected on monthly income and monthly spending on restaurant meals in Vancouver is 0.18.What does this mean?
The R2 for the data on sales and promotional spending for Smith and Klein Manufacturing is 0.83, which is a relatively high value. Does this mean that the least squares regression line is a good model in this case?
Interpret the coefficient of determination for the data set on semester average marks. Given this number, can you conclude that the way to increase student marks is to keep students from working while they are studying?
Interpret the coefficient of determination for the data set of total revenues and total numbers of employees for the top 25 global research organizations. Given this number, can you conclude that the way to increase revenues is to increase the number of employees at a company?
If appropriate, create a 98% confidence interval for the average sales at the Hendrick Software Sales Company, for 10 sales contacts.
If appropriate, create a 95% prediction interval for the amount of monthly spending on restaurant meals, based on a monthly income of $6,000.
If appropriate, create a 99% prediction interval for the total revenue of a global research company with 10,000 employees.
Smith and Klein Manufacturing have data on annual sales and the annual amount spent on promotions. Create an appropriate scatter diagram for these data. What is the least-squares regression line? Interpret it.
A college professor has collected data for a random sample of 43 of her students. She has their final semester average marks, and the total number of hours each spent working during the semester. The professor has hired one of her students to help her analyze the data, and the student has estimated
The Top 25 global research organizations include companies such as The Nielsen Company, the Ipsos Group, and Harris Interactive. Data about global research revenues (in US$ millions) and the number of full-time employees have been collected for 2007.1 The question that interests the researcher is
Check that the requirements for the theoretical model are met for the data from the Hendrick Software Sales Company. Are there any outliers? Are there any influential observations?
Check that the requirements for the theoretical model are met for the data on monthly incomes and monthly spending on restaurant meals. Are there any outliers? Are there any influential observations?
Check that the requirements for the theoretical model are met for the data on sales and promotion spending for Smith and Klein Manufacturing.
Check that the requirements for the theoretical model are met for the data on semester average marks and hours spent working. When the professor checked the data, she noticed that there were two unusually low marks: a 22 and a 28. When she investigated further, she realized that the students with
Check the requirements for regression for the data set of the TSX and the DJI described in Exercise 8.Is this data set a random sample?
A statistics professor wants to know whether a student's mark on the second statistics test is a good indicator of the student's mark on the final exam. She records the two marks for a random sample of students. Create a scatter diagram, and estimate and interpret the relationship between the two
Check the requirements for regression for the data set of student marks on the second test and the final exam in a statistics course, described in Exercise 11.
An excerpt from Excel's regression output for the data set of student marks on the second test and the final exam in a statistics course, described in Exercise 11, is shown below in Exhibit 13.48. Using the output, test for evidence of a positive slope between the two variables, with
a. If appropriate, construct a 95% confidence interval estimate for the average exam mark of students who had a mark of 65% on the second test of a statistics course (using the data set described in Exercise 11).b. If appropriate, construct a 95% interval estimate for the exam mark of a student who
Aries Car Parts maintains inventory of a wide array of car parts. The owner is old-fashioned, and has not allowed computers to be used in the business, so records are kept manually. An auditor has calculated the actual value of inventory for a random sample of car parts, and has compared this with
Check the requirements for regression for the data set of actual and recorded inventory values for Aries Car Parts from Exercise 15.When the auditor examined the relationship, he noticed two outliers, for observations 1 and 25 (why are these outliers?). Careful double-checking made the auditor
If appropriate, test for evidence of a linear relationship between the actual and recorded inventory values for Aries Car Parts (using the amended data set from Exercise 16). Use α = 0.05.
Interpret the coefficient of determination for the data on actual and recorded inventory values for Aries Car Parts (using the amended data set from Exercise 16). Does this give you confidence in the recorded inventory values?
What is the relationship between revenue and profit? A random sample of the top 1,000 Canadian companies was selected, and revenue and profit for 2008 were recorded.6 Create a scatter diagram, and comment on the relationship. What is the coefficient of determination for this data set? Does the high
Why are regression prediction intervals wider than confidence intervals?
A large company has developed a written test to screen applicants, and the mark on this test has been a good predictor of employee suitability for the graduates that are hired. Because administering the test is time-consuming and costly, the company is wondering if it is worthwhile. One cheaper
Check the requirements for regression for the data set of overall average marks and company test scores from Exercise 20. In exercise A large company has developed a written test to screen applicants, and the mark on this test has been a good predictor of employee suitability for the graduates
An excerpt of the Excel Regression output for the data set in Exercise 20 is shown in Exhibit 13.49 on the next page. If appropriate, use the output to test for evidence of a positive relationship between overall average marks and company test scores for this data set.In exercise A large company
If appropriate, create a 98% confidence interval estimate for the average test score of graduates with an overall average mark of 75, based on the data set described in Exercise 20.In exerciseA large company has developed a written test to screen applicants, and the mark on this test has been a
If appropriate, create a 98% interval estimate to predict the test score of a student with an overall average mark of 75, based on the data set describe in Exercise 20. Do you think the company should continue to administer its own test in interviewing graduates? In exercise A large company has
Why is it not recommended to make predictions outside the range of the sample data on which the regression relationship is based?
Why should you think carefully about any obvious outlier in the sample data set for a regression relationship, rather than simply removing it?
What determines the price of a used car? One of the factors is the odometer reading. A data set of the number of kilometres on the odometer and the asking price for a 2006 small sedan with an automatic transmission is available. Create a scatter diagram for the data set, and describe the

Showing 19300 - 19400 of 88243

First
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
Last

Step by Step Answers

Services

Sitemap
Fun
Definitions
Become Tutor
Used Textbooks
Study Help Categories
Recent Questions
Expert Questions
Campus Wear
Sell Your Books

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship
Online Quiz
Give Feedback, Get Rewards

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Student Discount
Campus Ambassador

Secure Payment

Download Our App

© 2026 SolutionInn. All Rights Reserved