Purchase Solution

Variable to Predict Amounts of Depositions for the British Bank

Not what you're looking for?

Ask Custom Question

1. (2.5 points) The British Bankers' Association decided to look at a variable to predict amounts of deposits. It chose the number of branches for each bank. The data are:

Bank Name Deposits (£ billion) Branches in 2006
Abbey National 101.7 867
Barclays 108.2 1997
Lloyds 96.9 2797
National Westminster 113.8 1920
Woolrich 27.5 430
Halifax 77.1 938

Results of SLR model analysis of the data include:

? The regression model is = 51.97 +0.024X
? The t-test statistic for Branches is 1.775 and the p-value is 0.1505
? R2 for this model is 44%

(a) At the 5% level, is the model statistically significant?

(b) What does the R2 mean?

(c) Suppose Roberts Bank was also a member of the British Bankers' Association and had 600 branches in 2006. Could you use this model to predict the amount of deposits in Roberts Bank? If so, what would your prediction be?

(d) Suppose they built a second SLR model, this time looking at the number of customers at each bank to predict deposits, with R2 for this model equal to 75%. Which variable do you think is more strongly related to deposits? Why?

2. (2.5 points) Quarterly sales for the Hudson Marine Co. for the past seven years are:

Year
Quarter 1
Quarter 2
Quarter 3
Quarter 4 Total
Yearly Sales
1 6 15 10 4 35
2 10 18 15 7 50
3 14 26 23 12 75
4 19 28 25 18 90
5 22 34 28 21 105
6 24 36 30 20 110
7 28 40 35 27 130

Seasonal indices (indexes) for the four quarters are:

Quarter Index
1 0.899
2 1.362
3 1.118
4 0.621

(a) When does Hudson Marine Co. experience the greatest seasonal effect? Does this seem reasonable? Explain.

(b) The trend equation of deseasonalized sales is = 6.332 +1.055 tcoded with R2 = 0.89 What are the forecasts for the four quarters of this year (year eight)?

Attachments
Purchase this Solution
Solution Summary

The solution examines the research for the British Bankers Association.

Purchase this Solution
Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting in a Health Care Center

    How many patients are seen for minor muscle strains/sprains, on a daily, weekly and monthly basis, to order the right amounts of pain medications?

  • British Bankers Association

    5528 British Bankers Association Regression Analysis The British Bankers Association wanted to look at the relationship between the amount of deposits made in billions and the number of customers the bank had............

  • Currency Conversion

    110528 Currency Conversion The product converts amounts of money from one currency to another currency. Five currencies are to be used. The currencies are: U.S. Dollars Canadian Dollars Japanese Yen Indian Rupees British Pounds.

  • Prediction, Regression, and Correlation Analysis

    slope or the change in y for any 1-unit change in x In the straight-line relationship, the predicted variable is the dependent variable while the variable that is used to predict another variable is the independent variable.

  • Manipulated independent variable

    Contrast this with the definition of the dependent variable-- the dependent variable is a variable you are trying to predict (i.e., decreased mental ability or increased hallucinations).

  • Applied Statistics for Health Care

    So, for example, if one was trying to predict the duration of breastfeeding in months using a mother's age as a predictor variable, one would use the regression model.

  • International Financial Management

    D) none of these. 2: Under a letter of credit arrangement, the bank issuing the letter of credit is known as the _______ bank, the correspondent bank in the beneficiary's country to which the issuing bank sends the letter of credit is known as the

  • How to interpret regression analyses of population on sales

    It is feasible to say the annual sales of offices are related to the population of the communities they are in. The dependent variable, y, is annual sales. The independent variable, x is market population.

  • Currency Rates

    What should the spot rate of U.S. dollars for BPs be at the end of the year in order for the bank to earn a net interest income of $200,000 (disregarding any change in principal values)?

View More Related Solutions