Question: Excel Assignment: Descriptive Statistics Introduction This is the introductory assignment to Excel, asking you to perform some basic skills. This assignment asks you to practice

Excel Assignment: Descriptive Statistics Introduction This is the "introductory assignment" to Excel, asking you to perform some basic skills. This assignment asks you to practice creating formulas or using commands in Excel. There are several ways to fulfil the requirements below-it is entirely up to you what resources you use to complete this assignment. This assignment is not meant to be completed on your own without help! Access the resources on Blackboard, contact the instructor or a T.A., and utilize any computer help resources UND has to offer if you are unsure of the basics of using the program. Problems 1. Download the file that accompanies these instructions titled "Excel Assignment Descriptives.xls". ^ 2. To grade this assignment, we will copy/paste a dataset of N = 20 numbers into cells B2 through B21 of the dataset. Next, we will look for the Excel file to automatically calculate several numbers. These values are described in this assignment and the corresponding cells in Excel will be highlighted in yellow a. You will not be provided with the dataset we are using. Your Excel file should be automatically performing calculations regardless of what data is entered. If you want to check that your Excel file is performing calculations correctly, I recommend creating your own example dataset and calculating the answers using a different program or by hand. If Excel's answers match your own answers, this indicates that your file is set up correctly. 3. In column C, provide the mean of Dataset X. 4. In column D, provide the sum of Dataset X. a. Can also be written as

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!