| Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel formulas) | |||||||
| Discount rate | 0.08 | ||||||
| 0 | 1 | 2 | 3 | ||||
| System A | |||||||
| Costs | |||||||
| Hardware | 14000 | 3000 | 3000 | 3000 | |||
| Software | 12000 | 2000 | 2000 | 1000 | |||
| Services | 2500 | 2500 | 2500 | 2500 | |||
| Benefits | |||||||
| Increased productivity | 15000 | 10000 | 5000 | ||||
| Lower Error rates | 18000 | 5000 | 6000 | ||||
| System B | |||||||
| Costs | |||||||
| Hardware | 15000 | 3000 | 3000 | 3000 | |||
| Software | 12000 | 4000 | 2000 | 5000 | |||
| Services | 7000 | 3000 | 3000 | 1000 | |||
| Benefits | |||||||
| Increased productivity | 7000 | 10000 | 10000 | ||||
| Reduced Work Force | 15000 | 15000 | 15000 | ||||
In: Accounting
In: Accounting
1. What role does tenure play in analyzing customer profitability for online and offline customers? (Do a regression analysis with 9profit as the dependent variable and 9tenure and 9online as independent variables. Discuss the results of the regression. Include - R-square and its interpretation, results of hypothesis testing on whole model's significance and the significance of individual variables.)
2. We want to compare profit from 1999 to profit from 2000 for the same customers. Profit for the same customers in year 2000 given by the variable 0profit. As you can see in the data set, some of the data for year 2000 is missing. How would you compare the profit from 1999 to 2000 if some data is missing? (Here you don't have to do the actual comparison. You don't have to do a hypothesis test. You should discuss how you would handle missing data)
please use the attached link for the data given:
https://drive.google.com/file/d/1jSekuFbrHLLJT6KXDz8TiMzcpfG6aVTD/view
In: Statistics and Probability
Essential Statistics for the Behavioral Sciences. Second Edition Chapter 10, #22: A clinical psychologist noticed that the siblings of his obese patients are often not overweight. He hypothesized that the normal-weight siblings consume fewer daily calories than the obese patients. To test this using a matched-pairs design, he compared the daily caloric intake of obese patients to that of a "matched" normal-weight sibling. The calories consumed for each sibling pair are given in the table. Normal-Weight Sibling: 1600, 1800, 2100, 1800, 2400, 2800, 1900, 2300, 2000, and 2050. Overweight Sibling: 2000, 2400, 2000, 3000, 2400, 1900, 2600, 2450, 2000, and 1950. [a] Test whether or not obese patients consumed significantly more calories than their normal-weight siblings at a 0.05 level of significance. State the value of the test statistic and the decision to retain or reject the null hypothesis. [b] Compute effect size using omega-squared. [c] Did the results support the researcher's hypothesis? Explain.
In: Statistics and Probability
A consumer buying cooperative tested the effective heating area of 20 different electric space heaters with different wattages. Here are the results.
| Heater | Wattage | Area |
| 1 | 1500 | 86 |
| 2 | 2000 | 129 |
| 3 | 1250 | 161 |
| 4 | 2000 | 224 |
| 5 | 2000 | 82 |
| 6 | 2000 | 99 |
| 7 | 750 | 80 |
| 8 | 1250 | 228 |
| 9 | 2000 | 282 |
| 10 | 1000 | 50 |
| 11 | 2000 | 279 |
| 12 | 1500 | 179 |
| 13 | 1500 | 206 |
| 14 | 750 | 44 |
| 15 | 1250 | 150 |
| 16 | 1250 | 293 |
| 17 | 1500 | 228 |
| 18 | 1000 | 222 |
| 19 | 1000 | 106 |
| 20 | 1750 | 187 |
1. Compute the correlation between the wattage and heating area. Is there a direct or an indirect relationship. (Round your answer to 4 decimal places.)
The correlation of Wattage and Area is _________. The link (relationship) is_________
2. Conduct a test of hypothesis to determine if it is reasonable that the coefficient is greater than zero. Use the 0.100 significance level. (Rond intermediate calculations and final answer to 3 decimal places.)
H0: ρ ≤ 0; H1: ρ > 0 Reject H0 if t > 1.330
t=___________
________H0, it is quite reasonable to say the population correlation is________
3. Develop the regression equation for effective heating based on wattage. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places.)
The regression equation is _________=_______+________ _________
4. Which heater looks like the “best buy” based on the size of the residual? (Round residual value to 3 decimal places.)
The ______ heater is the "best buy." It heats an area that is ________ square feet larger than estimated by the regression equation.
In: Statistics and Probability
Faulty information gathering usually adversely affects the decision-making process. Discuss ways of ensuring that faulty information is not gathered and how to solve problems when faulty information has become part of the overall information database.
In: Nursing
The number of database queries made during any interval of time is a Poisson random variable. On average, six queries are made every minute. Determine the probability that three or more queries will be made during an interval of 15 seconds.
In: Statistics and Probability
A certain business keeps a database of information about its customers. A. Let C be the rule which assigns to each customer shown in the table his or her home phone number. Is C a function? Explain your reasoning.
In: Math
How does preferred stock differ from both common equity and debt? Is preferred stock more risky than common stock? What is floating rate preferred stock?
Need answer not in Chegg Database and source.
In: Finance
In: Computer Science