Question

6. An investment banking firm was considering two spreadsheet software for possible use in its large data analysis operations. A sample of 20 typical analysis problems were carried out using both software on the firm’s standard personal computer. The time in minutes needed to load the data, program the spreadsheet calculations, carry out the analysis, and print the results was recorded for each problem for each software. The data for software A are stored in column 1 of the Excel data file named “Banking Spreadsheet.” The corresponding data for software B are stored in column 2. Each of the rows corresponds to one of the 20 problems. After conducting statistical tests on the mean of the differences in the minutes taken by the two software, a data analyst for the company concluded that there is no substantive difference between the two software in terms of the speed with which they process the data. In other words, he thought the mean of the differences in the minutes taken by the two software is statistically negligible. As a result he decided to recommend software B because he thought it is more user-friendly than software A. Using the same data and at 1% level of significance, please conduct the test you think the analyst’s recommendation must have been based on. Based on your results would you agree with the analyst’s conclusion? Does your conclusion change at 10% level of significance? Please show all the necessary steps and justify your answer in each case

Spreadsheet A |
Spreadsheet B |

10 |
10 |

23 |
23 |

24 |
24 |

19 |
17 |

21 |
12 |

26 |
22 |

14 |
13 |

19 |
16 |

12 |
18 |

35 |
28 |

34 |
25 |

23 |
28 |

28 |
27 |

24 |
20 |

38 |
33 |

20 |
20 |

31 |
27 |

29 |
24 |

35 |
28 |

24 |
25 |

Answer #1

An investment banking firm was considering two spreadsheet
software for possible use in
its large data analysis operations. A sample of 20 typical
analysis problems were carried
out using both software on the firm’s standard personal
computer. The time in minutes
needed to load the data, program the spreadsheet calculations,
carry out the analysis, and
print the results was recorded for each problem for each
software. The data for software
A are stored in column 1 of the Excel data...

An investment banking firm was
considering two spreadsheet software for possible use in its large
data analysis operations. A sample of 25 typical analysis problems
were carried out using both software on the firm’s standard
personal computer. The time in minutes needed to load the data,
program the spreadsheet calculations, carry out the analysis, and
print the results was recorded for each problem for each software.
The data for software A are stored in column 1 of the Excel
data...

Use MegaStat, MINITAB, or another software package to perform
Tukey’s test for significant pairwise differences. Perform the test
using both the 5 percent and 1 percent levels of
significance.
One particular morning, the length of time spent in the examination
rooms is recorded for each patient seen by each physician at an
orthopedic clinic.
Time in Examination Rooms (minutes)
Physician 1
Physician 2
Physician 3
Physician 4
35
34
19
28
22
37
30
32
29
30
31
31
31...

Use MegaStat, MINITAB, or another software package to perform
Tukey’s test for significant pairwise differences. Perform the test
using both the 5 percent and 1 percent levels of
significance.
One particular morning, the length of time spent in the examination
rooms is recorded for each patient seen by each physician at an
orthopedic clinic.
Time in Examination Rooms (minutes)
Physician 1
Physician 2
Physician 3
Physician 4
34
32
19
26
22
34
28
35
25
36
30
32
32...

A manufacturing company is purchasing metal pipes of standard
length from two different suppliers, ABC and XYZ. In the past two
months there are increasing complaints by the Production Manager
that delivery times by ABC present higher variability in comparison
to the delivery times by XYZ. The Production Manager is worried
that this variability will make it harder to efficiently schedule
the production process.
Does the sample data indicate a statistically significant
difference at the 5% level? Justify your answer....

A manufacturing company is purchasing metal pipes of standard
length from two different suppliers, ABC and XYZ. In the past two
months there are increasing complaints by the Production Manager
that delivery times by ABC present higher variability in comparison
to the delivery times by XYZ. The Production Manager is worried
that this variability will make it harder to efficiently schedule
the production process. Does the sample data indicate a
statistically significant difference at the 5% level? Justify your
answer....

The Columbus Dispatch conducted a study. Two identical football,
one filled with helium and one filled with ordinary air, were used.
A casual observer was unable to detect a difference in the two
footballs. A novice kicker was used to punt the footballs. A trial
consisted of kicking both footballs in a random order. The kicker
did not know which football he was kicking. The distance of each
punt was recorded, then another trial was conducted. A total of 39...

A research council wants to estimate the mean length of time (in
minutes) that the average U.S. adult spends watching television
using digital video recorders (DVR’s) each day. To determine the
estimate, the research council takes random samples of 35 U.S.
adults and obtains the following times in minutes.
24
27
26
29
33
21
18
24
23
34
17
15
19
23
25
29
36
19
18
22
16
45
32
12
24
35
14
40
30
19
14...

The SAT and the ACT are the two major standardized tests that
colleges use to evaluate candidates. Most students take just one of
these tests. However, some students take both. The data data141.dat
gives the scores of 60 students who did this. How can we relate the
two tests? (a) Plot the data with SAT on the x axis and ACT on the
y axis. Describe the overall pattern and any unusual observations.
(b) Find the least-squares regression line and...

The SAT and the ACT are the two major standardized tests that colleges use to evaluate candidates. Most students take just one of these tests. However, some students take both. The data data18.dat gives the scores of 60 students who did this. How can we relate the two tests?
(a) Plot the data with SAT on the x axis and ACT on the
y axis. Describe the overall pattern and any unusual
observations.
(b) Find the least-squares regression line and...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 1 minute ago

asked 5 minutes ago

asked 6 minutes ago

asked 26 minutes ago

asked 37 minutes ago

asked 43 minutes ago

asked 50 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago