Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please download data le Midterm Mark and Mortgage Rate from Brightspaoe - Assignments - Written Assignment 1. The data is about midterm mark. It is
Please download data le "Midterm Mark" and "Mortgage Rate" from Brightspaoe - Assignments - Written Assignment 1. The data is about midterm mark. It is randomly selected 500 students from 1DDD students taking a university level statistics course. Questions 1 to I" are based on "Midterm Mark". Question 3 is based on \"Mortgage Rate". 1. [Submit a screenshot of the histogram} Create a histogram for column "Midterm" using Excel Data Analysis Function with the following bin in data range C2: (3?. Output range is E1. Adjust the chart so that the lower right corner is in cell P20. Edit the chart title so that it is read as \"Created by Pauline Fu" [replace Pauline Fu with your name}. Rename the bin in column E so that it includes both the lower limit and upper limit {for example, it to 49. t] to 59. BC! to 69 etc}. Add data labels - outside end. Remove gap among bars [set gap width to {1%}. Bin 49 59 69 YB 89 99
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started