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
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
5
Tutorials:
0
Feedback Score:

Purchase it
Report this Question as Inappropriate
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

Tags cashier chief clearing cashier banks chief cash balance checks value weeks interval point daily written dollar excel just thee observations functionsthe available period recorded bank balances longer check shown provide predictions forecasts

Tutorials for this Question

Available for
$25.00

Chief Cashier

Tutorial # 00077646
Posted On: 07/16/2015 02:55 PM
Posted By:
Best Tutors for school students, college students neil2103
Expert tutors with experiences and qualities
Questions:
9341
Tutorials:
13656
Feedback Score:
Report this Tutorial as Inappropriate
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.....
Purchase this Tutorial @ $25.00 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
Loading...