Question: answer question a to be in word please. i have already attached the data , see attachment 2 and 3 Customer ID Customer ID Number

answer question a to be in word please.

i have already attached the data , see attachment 2 and 3

data , see attachment 2 and 3 Customer ID Customer ID Number

Customer ID Customer ID Number 6 Branch Branch Name Gender : M = Male; F = Female Age: Age of customers 11 12 Income: Personal income in thousands 13 14 Deposit Before: Amount of deposits before the change; in thousands 15 Deposit After: Amount of deposits after the change; in thousands 17 18 Increase in Deposits Increase in deposits since the change (in thousands) ; it equals to Deposits After minus Deposits Before 19 20 Loans Before: Amount of loans before the change; in thousands 2 Loans After: Amount of loans after the change; in thousands 23 24 Increase in Loans Increase in Loans since the change (in thousands); it equals to Loans After minus Loans Before 15 26 Rating Rating of the Bank's friendliness to its customers (on a scale of 1-10) Recommend Before: Before the change, whether customer would recommend the Bank to their friends and family; Yes = Recommend; No = Not Recommend 19 Recommend After: After the change, whether customer would recommend the Bank to their friends and family; Yes = Recommend; No = Not Recommend 12 33 34 Raw Data can be found under the "Raw Data" Tab! 38 43 44 16Deposit BeforeDeposit Afteincrease in Deposit Loans BeforeLoans After Increase in Loans Rating Recommend Before Recommend After Income 46.0 7.2 Yes Customer ID Gender $89882869 Branch Brock M B. 4 B. 1 4.2 63.5 B.0 63.0 8.7 No 61.0 24.2 Brock 47.4 5.4 Yes Yes 44.4 6.1 No Brock 63.7 13.4 49.7 5.0 Yes 100 58.0 48 .8 20.4 13.5 No Yes 101 102 57.2 17.4 103 Brock 63.5 104 43.6 105 14.9 16.1 Chase Chase Chase 19.3 Chase Chase Chase Chase Chase Chase Yes Yes 131 58.7 Yes 52.5 Davey 62.7 Yes Yes 49.9 Yes Davey Davey 45.2 No Davey 48.2 Yes Davey 53.7 Yes Davey 62.7 Davey 6.5 No Davey Davey Davey Yes 144 Davey Davey Yes 145 Yes Yes 146 Davey 147 Davey Davey 9.8 148 149 vey 51.7 15.4 150 Davey 56.1 151 Davey 152 Davey Davey 17 0.5065789472. Use the data in BUS|1013 Bank Dataset.xlsx to answer this question. (4 points each; 8 Points in total) a. Perform a statistical test to see whether the proportion of members who would recommend the Bank to their family and friends have increased because of the change. b. Construct a 99% confidence interval for the difference of the proportions, before and after the change, of members who would recommend the Bank to their family and friends

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

3. Use the data in BUSI1013 Chase Dataset.xlsx to answer these questions: BUSI 1013 Bank Dataset Legend and Coding: Customer ID Customer ID Number Branch Branch Name Gender : M = Male; F = Female...

Use the data in BUSI1013 Bank Dataset.xlsx(see below) to answer this question. (4 points) a Perform a statistical test to see whether the proportion of female customers in the population is lower...

Use the data in BUSI1013 Bank Dataset.xlsx(see below) to answer this question. (4 points) a Perform a statistical test to see whether the average Increase in Loans in the population is higher than...

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

Data model for Pine Valley Furniture Company in Microsoft Visio notation Please help me write queries to the following question that I have below: Thank you so much for your time and effort helping...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

ROBE Math 1530 - all sections Summer 2015 About the Summer 2015 Math 1530 Capstone project In the regular Fall and Spring semesters, the end-of-semester Math 1530 Capstone Project uses data collected...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Your name: Your Summer 2017 Math 1530 Section number: Your E number: MATH 1530 CAPSTONE TECHNOLOGY PROJECT SUMMER 2017 Problem 1: Identify Variable Type. Which of these questions from the class...

I am doing tax return project. attachments are the materials professor provide. He wants me to do a current year engagement file (Similar with prior year engagement file). AC 371 Tax Return Project...

Haddock Corp. purchased ten $1,000 0% bornds of Solar Corporation whan the market rate of interest was 12%. Interest is paid somiannually, and the bonds will mature in six years. Using the PV...

Let P0 be the initial price level (say, a price index such as the CPI). Let p be the inflation rate per period. (a) If Pt is the price at the end of period t, show that Pt = P0(1 + p)t (b) If P0 =...

Who can be considered an insider in terms of cybersecurity? An employee who has access to company IT resources A ropate worker with a badge to access company areas A customer purchasing products from...

Given the information: Inflation rate in US (th): Inflation rate in Europe (1h): The current spot rate of EUR (SR): 3.5% 8.0% $1.15 According to Purchasing Power Parity, one year later, the expected...