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 statistics using excel
Basic Business Statistics Concepts And Applications 5th Edition L. Berenson Mark, David Levine, Kathryn Szabat, Judith Watson, Nicola Jayne, Martin O'brien - Solutions
If the values of X in problem 12.1 range from 2 to 25, should you use this model to predict the average value of Y when X equals:a. 3?b. −3?c. 0?d. 24?
Fitting a straight line to a set of data yields the following prediction line:Ŷi = 15 + 25Xia. Interpret the meaning of the Y intercept, b0.b. Interpret the meaning of the slope, b1.c. Predict the mean value of Y for X = 12.
A debate in educational institutions has followed the issue of whether falling tutorial attendance can be addressed by marking attendance in class in universities. The argument is that attendance dropping will increase failure rates and this is an inefficient system of education provision. A
The Tertiary Certificate of Teaching has been introduced in Australian universities to help improve the quality of teaching offered in the classroom. From a sample of student responses to teaching quality, across several subjects at a university in Sydney, the following data were collected:
In problem 3.48 on page 132, you were introduced to a tea-bagfilling operation. An important quality characteristic of interest for this process is the weight of the tea in the individual bags.The data in the file < TEABAGS > are an ordered array of the weight, in grams, of a sample of 50 tea-bags
Tourism Australia reports in its China Market Profile that in 2016 there were two key factors that were equally most important for visitors in choosing Australia as their destination. Both ‘Safety and security’ and ‘World-class nature’ were chosen by 40% of visitors as key factors in their
Students in a business statistics course performed a completely randomised design to test the strength of four brands of garbage bags. One hundred gram weights were placed into a bag one at a time until the bag broke. A total of 40 bags, 10 for each brand, was used. The data in the file<
One operation of a mill is to cut pieces of steel into parts that are used later in the frame for front seats in a passenger car.The steel is cut with a diamond saw and requires the resulting parts to be within plus or minus 0.125 mm of the length specified by the car-manufacturing company. The
A researcher analysing gender pay differences has conducted a survey of male and female income (in dollars) for aged-care workers in a nursing home:
A university in Melbourne is testing the effects of alcohol consumption on the cognitive performance of a group of male students. Thirty students are recruited and randomly assigned to one of three groups where they are required to drink either five, one or zero standard drinks of the same alcohol
The manager of a paint supply store wants to determine whether the mean amount of paint contained in 4-litre cans purchased from a nationally known manufacturer is actually 4 litres. You know from the manufacturer’s specifications that the standard deviation of the amount of paint is 0.08 litres.
The Australian Government has endorsed a National Disability Strategy to deal with issues such as the divide in employment opportunities for disabled and able-bodied workers. In 2015 an ABS survey found an employment rate of 53.4% for people with a disability and 83.2% for people without a
Non-destructive evaluation (NDE) is a method used to describe the properties of components or materials without causing any permanent physical change to the units. It includes the determination of properties of materials and the classification of flaws by size, shape, type and location. This method
Assume that two suburbs of Sydney, Narrabeen and Coogee, are being considered as sites for government-subsidised day-care centres. Of 150 households surveyed in Narrabeen, the proportion in which the mother worked full-time was 44%. In Coogee, of 100 households surveyed, 38% had mothers who worked
While the use of cash is declining, bank ATMs must still be stocked with enough cash to satisfy customers making withdrawals over an entire weekend. Customer goodwill depends on such services meeting their needs. At one branch, the population mean amount of money withdrawn from the ATM per customer
A manufacturer of torch batteries took a sample of 13 batteries< BATTERIES > from a day’s production and used them continuously until they failed to work. The life of the batteries in hours until failure is:342 426 317 545 264 451 1,049 631 512 266 492 562 298a. At the 0.05 level of significance,
A key part of most Central Banks’ mission is the stability of a country’s financial system. With this in mind, the Governor of the Reserve Bank of Australia wishes to compare the volatility of the exchange rate of Australia (population 1) with that of New Zealand (population 2). A sample of
In 2017 Australia’s major banks decided to remove fees for the use of their ATMs by customers of foreign (other banks). The data in < BANK_COST2 > represent the number of foreign bank ATM transactions made by 26 customers of bank A in one month since the change was made.12 8 5 5 6 6 10 10 9 7 10
In July 2017 the Fair Work Commission reduced the penalty rates for work on a Sunday and public holidays in the retail and hospitality sectors. A representative from an employers association wishes to determine if average weekly labour costs for its clients has decreased between June and July of
An internal control policy for Rhonda’s Online Fashion Accessories requires a quality assurance check before a shipment is made. The tolerable exception rate for this internal control is 0.05. During an audit, 500 shipping records are sampled from a population of 5,000 shipping records and 12
A business which sells flowers and gifts through Internet sales has found that the proportion of website hits from which sales result is 9.8%. After redesigning its website it takes a sample of 200 potential customers who browse the site and checks whether they make a purchase. Suppose that 24
The data in the file < BEER > represent the alcohol percentage and calorie content of a sample of 95 beers together with country of origin and type.Your task is to write a report based on a complete evaluation comparing the calories and alcohol content based on the type of beer – light, regular
Ignore the blocking variable in problem 11.54.a. ‘Erroneously’ re-analyse the data as a one-factor completely randomised design where the one factor (brands of wines) has eight levels and each level contains a sample of 12 independent observations.b. Compare the SSBL and SSE terms in problem
A recent blind wine tasting was held by the Pickled Palate Wine Club, during which eight wines under $14 were rated by club members. The region of origin and the price were not known to the club members until after the tasting had taken place. The wines rated (and the prices paid for them) were:·
Suppose that in problem 11.52, when setting up the experiment, the effects of the store outlet location (university, large shopping centre, street location) was studied in addition to the company name. Thus, instead of the one-factor completely randomised design given in problem 11.52, the
Does the price of fresh fruit smoothies differ between Boost juice, Naked juice and Funky juice outlets? A researcher collected the price of a sample of five products at each of the outlets (in dollars). < JUICE1 >a. At the 0.05 level of significance:i. is there evidence of a significant difference
A hotel wanted to develop a new system for delivering room service breakfasts. In the current system, an order form is left on the bed in each room. If the customer wishes to receive a room service breakfast, they place the order form on the doorknob before 11 pm. The current system requires
Suppose that, when setting up the experiment in problem 11.49, the operations manager is able to study the effect of side-to-side aspect in addition to air-jet pressure. Thus, instead of the onefactor completely randomised design in problem 11.49, a twofactor factorial design was used, with the
An operations manager wants to examine the effect of air-jet pressure (in pounds per square inch (psi)) on the breaking strength of yarn. Three different levels of air-jet pressure are to be considered: 30 psi, 40 psi and 50 psi. A random sample of 18 yarns are selected from the same batch, and the
The effects of the global financial crisis (GFC) (factor A) and location (factor B) are being studied on consumer confidence(measured on a scale of 10). < CONFIDENCE >a. At the 0.05 level of significance:i. is there a significant interaction between location and the GFC?ii. is there an effect due
How can you determine whether there is an interaction in the two-factor factorial design?
What is meant by the concept of interaction in a two-factor factorial design?
Under what conditions should you use the two-way ANOVA F test to examine possible differences between the means of each factor in a factorial design?
What is the difference between the one-way ANOVA F test and the Levene test?
When and how should you use multiple comparison procedures for evaluating pairwise combinations of the group means?
Under what conditions should you select the one-way ANOVA F test to examine possible differences between the means of c independent populations?
What are the assumptions of ANOVA?
What are the distinguishing features of the completely randomised design, randomised block design and two-factor factorial designs?
In a one-way ANOVA, what is the difference between the between-groups variance MSB and the within-groups variance MSW?
A student team in a business statistics course performed a factorial experiment to investigate the sales of a new product.The two factors were marketing technique (A, B, C) and geographical location of market (Newcastle and Wollongong).At the 0.05 level of significance:a. Is there a significant
A chef in a restaurant that specialises in pasta dishes was experiencing difficulty in getting brands of pasta to be al dente – that is, cooked enough so as not to feel starchy or hard but still feel firm when bitten into. She decided to conduct an experiment in which two brands of pasta, one
The effects of developer strength (factor A) and development time (factor B) on the density of photographic plate film were being studied. Two strengths and two development times were used, and four replicates for each treatment combination were run. The results (with larger values being best) are
From the results of problem 11.34, at the 0.05 level of significance:a. Is there an effect due to factor A?b. Is there an effect due to factor B?c. Is there an interaction effect?
Given a two-factor factorial experiment and the ANOVA summary table that follows, fill in all the missing results:
Given a two-way ANOVA with two treatment levels for factor A and five treatment levels for factor B, and four replicates in each of the 10 treatment combinations of factors A and B, with SSA = 18, SSB = 64, SSE = 60 and SST = 150:a. Form the ANOVA summary table and fill in all values in the body of
at the 0.05 level of significance:a. Is there an effect due to factor A?b. Is there an effect due to factor B?c. Is there an interaction effect?
to
Given the results from problems
Assume that you are working with the results of problem 11.30.a. What is the value of the test statistic F for the interaction effect?b. What is the value of the test statistic F for the factor A effect?c. What is the value of the test statistic F for the factor B effect?d. Form the ANOVA summary
Assume that you are working with the results from problem 11.29, and SSA = 120, SSB = 110, SSE = 270 and SST = 540.a. What is SSAB?b. What are MSA and MSB?c. What is MSAB?d. What is MSE?
Consider a two-factor factorial design with three levels for factor A, three levels for factor B and four replicates in each of the nine cells.How many degrees of freedom are there in determining:a. the factor A variation and the factor B variation?b. the interaction variation?c. the random
The data in the < CONCRETE2 > file represent the compressive strength in thousands of pounds per square inch of 40 samples of concrete taken 2, 7 and 28 days after pouring.a. At the 0.05 level of significance, is there evidence of a significant difference in the mean compressive strength after 2, 7
How different are the rates of return of money market accounts and certificates of deposit that vary in their term length?The data in < MMCD_RATE > contain the money market, one-year CD, two-year CD and five-year CD rates for banks in a suburban area (data obtained from ‘Consumer money rates’,
Remaindered books are often sold for prices much less than the original recommended retail price. They will usually be offered in low-rent shops or stalls set up within the open areas of shopping centres. The following data < BOOK_PRICE >shows five book titles and the prices the remaindered titles
At the major shopping centre in Chatswood, NSW, there are several large chemist shops which compete for business, often through advertising discounted prices or specials. The following data < CHEMISTS > shows prices for comparable items as shown on the shelves at three Chatswood chemist shops on 5
How do the ratings for TV, phone and Internet services compare?The data in < TELECOM2 > represent the mean ratings in 13 different cities (data obtained from ‘Ratings: TV, phone, and Internet services’, Consumer Reports, May 2013, 24–25).a. At the 0.05 level of significance, determine whether
Nine experts rated four brands of Colombian coffee in a tastetesting experiment. A rating on a seven-point scale (1 =extremely unpleasing, 7 = extremely pleasing) is given for each of four characteristics: taste, aroma, richness and acidity.The following table displays the summated ratings,
Refer to problem 11.21.a. At the 0.05 level of significance, is there evidence of a significant difference between the four treatment level means?b. At the 0.05 level of significance, is there evidence of a block effect?
Given a randomised block experiment with four treatment levels and eight blocks, from the ANOVA summary table below, fill in all the missing results.
From problem 11.19, if SSB = 36 and the randomised block F test statistic is 6.0:a. What is MSE and SSE?b. What is SSBL if the F test statistic for block effects is 4.0?c. What is SST?d. At the 0.01 level of significance, is there evidence of treatment and block effects?
Given a randomised block experiment with three treatment levels and seven blocks, how many degrees of freedom are there in determining:a. the between-group variation?b. the between-block variation?c. the random variation or error?d. the total variation?
and 11.17.a. To perform the Tukey procedure, how many degrees of freedom are there in the numerator and how many degrees of freedom are there in the denominator of the Studentised range distribution?b. At the 0.05 level of significance, what is the upper-tail critical value from the Studentised
Refer to problems 11.15,
and 11.16.a. Construct the ANOVA summary table and fill in all values in the body of the table.b. At the 0.05 level of significance, is there evidence of a significant difference in the population means?c. At the 0.05 level of significance, is there evidence of a significant difference due to
Refer to problems
Refer to problem 11.15.a. If SSB = 60, SSBL = 75 and SST = 210, what is SSE?b. What are MSB, MSBL and MSE?c. What is the value of the test statistic F for the difference in the four means?d. What is the value of the test statistic F for the block effects?
Given a randomised block experiment with four treatment levels and six blocks, how many degrees of freedom are there in determining:a. the between-group variation?b. the between-block variation?c. the inherent random variation or error?d. the total variation?
A sporting goods manufacturing company wanted to compare the distance travelled by golf balls produced by each of four different designs. Ten balls were manufactured with each design and brought to the local golf course for the club professional to test. The order in which the balls were hit with a
The retailing manager of a supermarket chain wants to determine whether product location has any effect on the sale of fluffy toys. Three different aisle locations are considered:front, middle and rear. A random sample of 18 stores is selected, with six stores randomly assigned to each aisle
Researchers conducted a study to determine whether graduates with an academic background in the discipline of leadership studies were better equipped with essential soft skills required to be successful in contemporary organisations than students with no leadership education and/or students with a
In a study of days taken on sick leave by people of different age groups, a human resources manager collects the following data: < SICK_LEAVE >a. At the 0.05 level of significance, is there evidence of a significant difference in the mean days taken on sick leave for the three age groups?b. If
A hospital conducted a study of the waiting time in its emergency room. The hospital has a main campus and three satellite locations. Management had a business objective of reducing waiting time for emergency room cases that did not require immediate attention. To study this, a random sample of 15
We wish to determine if there are significant differences in the unemployment rates of urban, regional and rural labour markets. < RURAL_UNEMP >a. At the 0.05 level of significance, is there evidence of a significant difference in unemployment rates in the three labour markets?b. If appropriate,
The Vice Chancellor of the University of Windang wants to determine if students’ average grades differ by course studied. A sample of five students’ grades is taken from four degree courses.a. Complete the ANOVA summary table.b. At the 0.05 level of significance, is there evidence of a
You are conducting an experiment with one factor containing five groups, with 10 values in each group. For the ANOVA summary table below, fill in all the missing results
You are working with the same experiment as in problem 11.5.a. At the 0.05 level of significance, state the decision rule for testing the null hypothesis that all six groups have equal population means.b. What is your statistical decision?c. At the 0.05 level of significance, what is the upper-tail
You are conducting an experiment with one factor containing six groups, with five values in each group. For the following ANOVA summary table, fill in all the missing results.
You are working with an experiment that has one factor containing six groups with seven values in each. How many degrees of freedom are there in determining:a. the between-group variation?b. the within-group variation?c. the total variation?
and 11.2.a. Form the ANOVA summary table and fill in all values in the body of the table.b. At the 0.05 level of significance, what is the upper-tail critical value from the F distribution?c. State the decision rule for testing the null hypothesis that all four groups have equal population means.d.
You are working with the same experiment as in problems
You are working with the same experiment as in problem 11.1.a. If SSB = 60 and SST = 120, what is SSW?b. What is MSB?c. What is MSW?d. What is the value of the test statistic F?
You are working with an experiment that has a single factor with four groups, and five values in each group. How many degrees of freedom are there in determining:a. the between-group variation?b. the within-group variation?c. the total variation?
The following information is available for two samples drawn from independent normally distributed populations:n2 = 21 S1 2 = 133.7 n2 = 16 S2 2 = 161.9
Determine FL, the lower-tail critical value of F, in each of the following one-tail tests:a. α = 0.05, n1 = 13, n2 = 25b. α = 0.025, n1 = 13, n2 = 25c. α = 0.01, n1 = 13, n2 = 25d. α = 0.005, n1 = 13, n2 = 25
Determine FU, the upper-tail critical value of F, in each of the following one-tail tests:a. α = 0.05, n1 = 8, n2 = 7b. α = 0.025, n1 = 9, n2 = 6c. α = 0.01, n1 = 7, n2 = 5d. α = 0.005, n1 = 9, n2 = 9
Determine FU and FL, the upper- and lower-tail critical values of F, in each of the following two-tail tests:a. α = 0.05, n1 = 8, n2 = 7b. α = 0.05, n1 = 9, n2 = 6c. α = 0.025, n1 = 7, n2 = 5d. α = 0.01, n1 = 9, n2 = 9
Does playing Lumosity increase one’s IQ? We collected IQ scores for a sample of 7 individuals before and after a 30-day trial of Lumosity. < LUMOSITY >
Most motorists believe that petrol stations put prices up on public holidays. A motorist advocacy group collected petrol price data for a sample of petrol stations on the Thursday before a public holiday and the Friday of the public holiday(measured in cents per litre). < PUBLIC_HOLIDAY >
To assess the effectiveness of a cola video ad, a random sample of 38 individuals from a target audience was selected to participate in a copy test. Participants viewed two ads, one of which was the ad being tested. Participants then answered a series of questions about how much they liked the ads.
How do the ratings of TV and phone services compare?The file < TELECOM > contains the rating of 13 different providers (data obtained from ‘Ratings: TV, phone, and internet services’, Consumer Reports, May 2012, p. 25).a. At the 0.05 level of significance, is there sufficient evidence of a
Travel expenses paid by companies can increase or decrease dramatically when there are changes in the daily rates for hotel rooms. Did these rates stay the same from 2011 to 2015? Assume that the following data < HOTEL_PRICE2 >give typical daily rates in Australian dollars for hotels in 18 cities
An experimental design for a repeated measures t test requires a measurement before and after the presentation of a stimulus to each of 11 subjects. How many degrees of freedom are there in this t test?
An experimental design for a paired t test has, as a matched sample, 12 pairs of identical twins. How many degrees of freedom are there in this t test?
The director of training for an electronic equipment manufacturer is interested in determining whether different training methods have an effect on the productivity of assembly-line employees.He randomly assigns 42 recently hired employees into two groups of 21. The first group receives a
Repeat problem 10.17(a) assuming that the population variances are not equal. Compare the results with those of problem 10.17(a).
Do male law graduates earn more than females? To address this proposition the Law Association collected a sample of salaries (in dollars) from newly graduated males and females.< STARTING_SALARY >
Repeat problem 10.15(a) assuming that the population variances for the two teams are not equal. Compare the results with those of problem 10.15(a).
A problem with a phone line, which is preventing a customer from receiving or making calls, is upsetting to both the customer and the telecommunications company. The file < PHONE >contains samples of 20 problems reported to two different offices of a telecommunications company and the time to clear
Repeat problem 10.13(a) assuming that the population variances are not equal. Compare the results with those of problem 10.13(a).
The Commercial Bank of Singapore (CBS) advertises that ‘our customers come first’ and claims that the waiting time for its customer inquiries is the lowest. A sample of 34 of its customers waited an average of 8 minutes with a standard deviation of 2.5 compared to an average of 9.5 minutes and
Showing 500 - 600
of 2900
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last
Step by Step Answers
Get 50% OFF
Claim Now
