Question

An investment banking firm was considering two spreadsheet software for possible use in its large 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 file named “Banking Spreadsheet.” The corresponding data for software B are stored in column 2. Each of the rows corresponds to one of the 25 problems. After constructing the 98% and 94% 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.                                                                              [4 points]

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
35 28
17 25
24 18
22 21
30 34

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
An investment banking firm was considering two spreadsheet software for possible use in its large data...
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...
6. An investment banking firm was considering two spreadsheet software for possible use in its large...
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...
descriptive statistics for the given data 4 8 18 20 21 22 23 24 25 26...
descriptive statistics for the given data 4 8 18 20 21 22 23 24 25 26 27 28 29 30 31 31 32 32 33 33 34 35 36 37 38 39 47 53
6. Using the class data (see Blackboard file - "Class Survey Data - PSS-10 and GAS")...
6. Using the class data (see Blackboard file - "Class Survey Data - PSS-10 and GAS") calculate the correlation between the GAS – Goal disengagement and the GAS – Goal reengagement scores. Write the results in a statistical statement. 7. Using the class data calculate the correlation between the GAS – Goal disengagement and the PSS-10 scores. Write the results in a statistical statement. 8. Using the class data calculate the correlation between the GAS – Goal reengagement scores and...
A manufacturing company is purchasing metal pipes of standard length from two different suppliers, ABC and...
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...
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...
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. If the variance of XYZ remains unchanged, what should be the variance of ABC in order...
A research council wants to estimate the mean length of time (in minutes) that the average...
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...
Use MegaStat, MINITAB, or another software package to perform Tukey’s test for significant pairwise differences. Perform...
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...
The Columbus Dispatch conducted a study. Two identical football, one filled with helium and one filled...
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...