# Textbook Solutions

### Tomato Farmer Two Population Means – Solution and Explanation

Two Population Means Answer Guide A tomato farmer with a very large farm of approximately 2200 acres had heard about a new type of rather expensive fertilizer which would supposedly significantly increase his production. The frugal farmer wanted to test the new fertilizer before [...]Read more

### Tomato Farmer Two Population Means – Spreadsheet Solutions

The spreadsheet below shows the hypothesis tests performed for the two population means of the tomato farmer. Tomato Farmer Two Population Means SpreadsheetRead more

### Tutorial: Sun Company Ending Inventory

Sun Company Ending Inventory Sun Company is trying to determine the value of its ending inventory as of March 31, 2014, the company’s year-end. The following transactions occurred, and the accountant asked your help in determining whether they should be recorded or not. (a) [...]Read more

### Frank Smith Plumbing Part 2: Financial Ratio Calculations

Frank Smith Plumbing Problem Data Before proceeding, make sure to check out the data in Frank Smith Plumbing Part 1. This data is necessary to perform the cash flow financial ratios below. Payback Period Find payback period by first finding the last year with a negative cash [...]Read more

### Statistics Guide: A study of long-distance phone calls made from General Electric Corporate Headquarters

In this tutorial, we provide an image of the formatting in an excel spreadsheet. For each problem we show the actual formula to plug into the cell and the result. Student Question: A study of long-distance phone calls made from General Electric Corporate Headquarters in [...]Read more

### Calculating Present Value with Varying Deposits: What is the present value of a $1,400 deposit…

Calculating Present Value with Varying Deposits Student Question: What is the present value of a $1,400 deposit at the end of year 1 and another $700 deposit at the end of year 5 if the interest rate is 8%? Solving this problem requires us to determine the impact of varying [...]Read more

### Statistics Guide: A normal population has a mean of 19 and a standard deviation of 5.

In this tutorial, we are going to use excel to calculate a z value from a know mean and standard deviation. Student Question: A normal population has a mean of 19 and a standard deviation of 5. Compute the z value associated with 25 To find the z-value at 25, we calculate (25 [...]Read more

### Statistics Guide: Customers experiencing technical difficulty with their internet cable hookup may call an 800 number for technical support

Student Question: Customers experiencing technical difficulty with their internet cable hookup may call an 800 number for technical support. It takes the technician between 150 seconds and 12 minutes to resolve the problem. The distribution of this support time follows the [...]Read more

### Statistics Guide: Solving the January Theory Stock Market Problem

Student Question: According to the “January theory” if the stock market is up for the month of January, it will be up for the year. If it is down in January,it will be down for the year. According to an article in The Wall Street Journal, this theory held for 28 out [...]Read more

### Statistics Guide: Internal Revenue Service is Studying Charitable Contributions

This tutorial requires Microsoft EXCEL for the computation of various statistical value. In order to follow along, please make sure you have a spreadsheet ready to go. Student Question: The Internal Revenue Service is studying the category of charitable contributions. A sample of [...]Read more