# Statistics Problems in Excel

## Transcribed Text

Balance ATM Services Debit Interest City \$ 9 2 1 0 1 748.00 \$ 10 1 0 0 1 1,501.00 \$ 17 3 0 1 1 1,886.00 \$ 10 8 1 0 1 1,593.00 \$ 12 7 1 0 1 1,474.00 \$ 6 5 0 0 1 1,913.00 \$ 10 3 1 0 1 1,218.00 \$ 12 4 0 0 1 1,006.00 \$ 7 2 0 0 1 343.00 \$ 11 2 0 1 1 1,494.00 \$ 4 1 0 0 1 580.00 \$ 4 5 1 0 1 1,320.00 \$ 11 5 0 0 1 1,784.00 \$ 7 5 1 0 1 1,044.00 \$ 7 1 0 1 1 890.00 \$ 13 3 1 0 1 1,708.00 \$ 150 57 7 3 20,502.00 Balance ATM Services Debit Interest City \$ 13 4 0 1 2 1,756.00 \$ 18 6 0 0 2 2,125.00 \$ 10 7 0 0 2 1,995.00 \$ 8 4 0 1 2 1,526.00 \$ 11 2 0 0 2 1,746.00 \$ 10 4 1 1 2 1,616.00 \$ 6 2 1 0 2 1,958.00 \$ 6 7 1 0 2 1,675.00 \$ 10 6 1 1 2 1,885.00 \$ 14 5 0 0 2 2,204.00 \$ 16 8 0 0 2 2,409.00 \$ 14 4 1 0 2 1,338.00 \$ 12 5 1 0 2 2,076.00 \$ 12 4 0 0 2 2,375.00 \$ 6 4 1 0 2 1,125.00 \$ 14 5 1 0 2 2,156.00 \$ 12 3 0 1 2 1,989.00 \$ 192 80 8 5 31,954.00 Balance ATM Services Debit Interest City \$ 8 6 1 0 3 1,120.00 \$ 7 5 1 1 3 1,838.00 \$ 12 7 0 1 3 1,735.00 \$ 16 8 0 0 3 1,326.00 \$ 11 4 0 1 3 1,790.00 \$ 2 0 0 0 3 32.00 \$ 9 5 1 1 3 1,455.00 \$ 10 4 0 1 3 1,831.00 \$ 6 3 0 0 3 740.00 \$ 12 6 1 0 3 1,554.00 \$ 7 2 0 0 3 137.00 \$ 15 4 1 0 3 2,276.00 \$ 17 3 0 0 3 2,144.00 \$ 8 4 1 0 3 1,053.00 \$ 140 61 6 5 19,031.00 Balance ATM Services Debit Interest City \$ 14 6 0 1 4 1,622.00 \$ 6 4 0 0 4 1,169.00 \$ 20 3 1 0 4 2,215.00 \$ 20 7 1 0 4 2,557.00 \$ 2 7 1 0 4 634.00 \$ 8 4 0 0 4 789.00 \$ 14 4 1 0 4 2,051.00 \$ 4 3 0 0 4 765.00 \$ 6 9 0 1 4 1,645.00 \$ 11 7 0 0 4 1,266.00 \$ 18 5 0 1 4 2,138.00 \$ 8 4 1 0 4 1,487.00 \$ 5 4 0 0 4 167.00 \$ 136 67 5 18,505.00 Balance ATM Services Debit Interest City \$ 1,756.00 13 4 0 1 2 \$ 748.00 9 2 1 0 1 \$ 1,501.00 10 1 0 0 1 \$ 1,831.00 10 4 0 1 3 \$ 1,622.00 14 6 0 1 4 \$ 1,886.00 17 3 0 1 1 \$ 740.00 6 3 0 0 3 \$ 1,593.00 10 8 1 0 1 \$ 1,169.00 6 4 0 0 4 \$ 2,125.00 18 6 0 0 2 \$ 1,554.00 12 6 1 0 3 \$ 1,474.00 12 7 1 0 1 \$ 1,913.00 6 5 0 0 1 \$ 1,218.00 10 3 1 0 1 \$ 1,006.00 12 4 0 0 1 \$ 2,215.00 20 3 1 0 4 \$ 137.00 7 2 0 0 3 \$ 167.00 5 4 0 0 4 \$ 343.00 7 2 0 0 1 \$ 2,557.00 20 7 1 0 4 \$ 2,276.00 15 4 1 0 3 \$ 1,494.00 11 2 0 1 1 \$ 2,144.00 17 3 0 0 3 \$ 1,995.00 10 7 0 0 2 \$ 1,053.00 8 4 1 0 3 \$ 1,526.00 8 4 0 1 2 \$ 1,120.00 8 6 1 0 3 \$ 1,838.00 7 5 1 1 3 \$ 1,746.00 11 2 0 0 2 \$ 1,616.00 10 4 1 1 2 \$ 1,958.00 6 2 1 0 2 \$ 634.00 2 7 1 0 4 \$ 580.00 4 1 0 0 1 \$ 1,320.00 4 5 1 0 1 \$ 1,675.00 6 7 1 0 2 \$ 789.00 8 4 0 0 4 \$ 1,735.00 12 7 0 1 3 \$ 1,784.00 11 5 0 0 1 \$ 1,326.00 16 8 0 0 3 \$ 2,051.00 14 4 1 0 4 \$ 1,044.00 7 5 1 0 1 \$ 1,885.00 10 6 1 1 2 \$ 1,790.00 11 4 0 1 3 \$ 765.00 4 3 0 0 4 \$ 1,645.00 6 9 0 1 4 \$ 32.00 2 0 0 0 3 \$ 1,266.00 11 7 0 0 4 \$ 890.00 7 1 0 1 1 \$ 2,204.00 14 5 0 0 2 \$ 2,409.00 16 8 0 0 2 \$ 1,338.00 14 4 1 0 2 \$ 2,076.00 12 5 1 0 2 \$ 1,708.00 13 3 1 0 1 \$ 2,138.00 18 5 0 1 4 \$ 2,375.00 12 4 0 0 2 \$ 1,455.00 9 5 1 1 3 \$ 1,487.00 8 4 1 0 4 \$ 1,125.00 6 4 1 0 2 \$ 12 3 0 1 2 1,989.00 \$ 2,156.00 14 5 1 0 2 \$89,992.00 618 265 26 16 The company identified is Century National Bank.( See data sets) The Problem: Marketing of the banking services is found wanting as the number of accounts that could be increased by marketing is underutilized. Marketing has to build customer base and utilization of services offered by the bank. We can evaluate and compare the services of the bank and consider what opportunities Century has to expand. (1) Perform a Regression Analysis on the data using Microsoft Excel. (2) Interprete the results of the regression analysis, state the limitations of the analysis, and describe the significance of the results.

## Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

\$20.00 for this solution

PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

### Find A Tutor

View available General Statistics Tutors

Get College Homework Help.

Are you sure you don't want to upload any files?

Fast tutor response requires as much info as possible.