# Attachment # 00006582 - Chief_Cashier.docx

Chief_Cashier.docx (18.66 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Perform in excel using excel functionsThe chief cashier of a bank must manage the cash holding so as to gain interest by investing excess cash where possible, but at the same time keep sufficient cash on hand to meet the bank's needs. A major issue for the chief cashier is the uncertainty that results from the Federal Reserve Board's (the Fed's) clearing balance. The clearing balance is the difference between the dollar value of checks written by the bank's customers and cleared through the Fed, and the dollar value of checks received but written on other banks and clear through the Fed.The chief cashier has recorded the last eight weeks of clearing balances (a longer period is available, but we will use just eight weeks here). Thee 40 observations of daily check clearings are shown below:1.Provide point and interval estimates of the mean daily clearing balance.2. Provide point and interval predictions (or forecasts) of tomorrows clearing balance.

# Question

Offered Price \$25.00

# Chief Cashier

Question # 00082957
Subject: Statistics
Due on: 07/18/2015
Posted On: 07/16/2015 02:36 PM

Rating:
4.1/5
Posted By
Questions:
7
Tutorials:
0
Feedback Score:

Question

Perform in excel using excel functions

The chief cashier of a bank must manage the cash holding so as to gain interest by investing excess cash where possible, but at the same time keep sufficient cash on hand to meet the bank's needs. A major issue for the chief cashier is the uncertainty that results from the Federal Reserve Board's (the Fed's) clearing balance. The clearing balance is the difference between the dollar value of checks written by the bank's customers and cleared through the Fed, and the dollar value of checks received but written on other banks and clear through the Fed.

The chief cashier has recorded the last eight weeks of clearing balances (a longer period is available, but we will use just eight weeks here). Thee 40 observations of daily check clearings are shown below:

1.Provide point and interval estimates of the mean daily clearing balance.

2. Provide point and interval predictions (or forecasts) of tomorrows clearing balance.

Attachments

# Tutorials for this Question

Available for
\$25.00

#### Chief Cashier

Tutorial # 00077646
Posted On: 07/16/2015 02:55 PM
Posted By:
neil2103
Questions:
9431
Tutorials:
13860
Feedback Score:
Tutorial Preview ……
Attachments
assignment-43-part2.xlsx (11.04 KB)
Preview: ErrorMedianModeStandard xxxxxxxxxxxxxxx VarianceKurtosisSkewnessRangeMinimumMaximumSumCountLargest(1)Smallest(1)Confidence.....
assignment-43-part2.xlsx (11.04 KB)
Preview: ErrorMedianModeStandard xxxxxxxxxxxxxxx VarianceKurtosisSkewnessRangeMinimumMaximumSumCountLargest(1)Smallest(1)Confidence.....
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable