Create a scatter plot to provide a visual representation

Assignment Help Financial Management

Reference no: EM131150094

Question 1:
Let's assume that the data of Century National Bank customers are random samples from four different cities of Century National Bank customers.

For each city complete the following items. Document you completed each item using an Excel work book.

1. Create a scatter plot to provide a visual representation of the relationship between the two variables - balance and ATM.

2. Calculate the correlation coefficient between the two variables - balance and ATM.

3. Test the hypothesis the correlation between the variables balance and ATM is zero:
H₀:p=0
H₀:p≠0

4. Find the regression equation that expresses the linear relationship between balance and ATM.

5. Test the hypothesis the slope of the regression equation is less than zero:
H0: β≤ 0
H0: β > 0

6. Summarize your finding for each city in a MS Word document.

7. Submit both your Excel workbook and your Word document.

Attachment:- Homework-MGSC-excel.rar

Reference no: EM131150094

Questions Cloud

Evaluate the planning function of management : Evaluate the planning function of management as it relates to the organization's goals and strategies. Use steps in the planning process outlined in the text

Write a expository essays on the topic euthanasia is human : Terminally ill people rarely die swiftly or comfortably. Their death experience is usually prolonged that leaves them in excruciating pain (Young). Euthanasia is "a deliberate act that causes death usually by a doctor with the primary intention of en..

What will the corresponding force on the prototype be : What will the velocity and flow of the prototype be? If the measured force on a certain part of the model is 1.5 N, what will the corresponding force on the prototype be?

What is the proper model flow rate : According to the web site USGS Daily Water Data for the Nation, the mean flow rate in the New River near Hinton, WV, is 10,100 ft3 /s. If the hydraulic model in Fig. 5.9 is to match this condition with Froude number scaling, what is the proper mode..

Create a scatter plot to provide a visual representation : Create a scatter plot to provide a visual representation of the relationship between the two variables - balance and ATM.

Define psychology and psychological adjustment : Identify contextual variables (e.g., culture) that impact psychological adjustment. Describe self-concept, self-esteem, and identity. Define stress, stressors, and coping strategies, and contemplate their relationship to health and wellness.

Describe the implications of each alternative action : Discuss alternative courses of action that could be taken by the counselor to rectify each dilemma. Describe the implications of each alternative action; lay out the limitations and advantages of each alternative considered.

Provide meaningful feedback on a minimum of acid rain : Each student will provide meaningful feedback on a minimum of three topics (other than assigned report topic) to the environmental problems reports by discussing the pros and cons of the solutions or suggest new solutions.

What details of scaling might be important in such studies : What details of scaling might be important in such studies?

User Account

All Pages