QuestionQuestion

Transcribed TextTranscribed 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 PreviewSolution 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.

Statistics Problems in Excel
    $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.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats