Question

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 constructing the 99% and 90% confidence intervals for

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, please calculate and interpret the

confidence intervals upon which the analyst’s recommendation was based. Based on your

results would you agree with the analyst’s conclusion? Please justify your answer.

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 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...

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...

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...

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...

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...

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...

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...

Second, the researcher wishes to use graphical descriptive
methods to present summaries of the data on each of the two
variables: hours worked per week and income earned per year, as
stored in HOURSWORKED63 worksheet.
c. Draw and display a histogram for each of the two variables
using appropriate BIN values from part (b) and comment on the shape
of the two distributions.
Data for HOURSWORKED63 Excel spreadsheet is below:
Yearly Income ('000's)
Hours Per Week
43.8
18
44.5
13...

e 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 data76.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 6 minutes ago

asked 19 minutes ago

asked 33 minutes ago

asked 40 minutes ago

asked 46 minutes ago

asked 57 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago