Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You will notice when you open a file that there are two worksheets: Data and Define Variables. The Data worksheet is the actual data that

You will notice when you open a file that there are two worksheets: Data and Define Variables. The Data worksheet is the actual data that accompanies the project. The Define Variables is the code book for the data. You will learn more about code books later but they are simply the instructions on how to code a survey when it is returned. The code book is important for you so you can make sense out of the Data file. Review both.

Complete the following projects:

Assignment #1:

Open the Friendly Market File.

How many survey respondents (data files) are in this data set?

Determine the number of people who shop at Circle K regularly? In your answer include the formula you used to determine the answer to this question.

Assignment #2:

Open the AAConcepts File

How many people responded to this survey?

How many respondents are between the ages of 25 to 34? In your answer include the formula you used to determine the answer to this question.

What is the Average age of the respondents to the survey? In your answer include the formula you used to determine the answer to this question

Assignment #3:

Now, you will notice on the top menu list for your Excel there is now an "Add-Ins" option. This is the Macros you enabled earlier and will be using throughout the remainder of this course. Click on Add-Ins. You will now see on the left "XL Data Analyst". Click on this option and you will see a drop down menu. Review each of the options in this list. Which options in this drop down list could have been used to answer the first two assignments you just completed? Make sure to list both the Data Analyst routine with the assignment, e.g. Summarize, Average could have been used to answer Assignment __ part ___.

Complete the above assignments and submit your answers to the Dropbox as a Word document

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Finance An Introduction to Financial Institutions, Investments and Management

Authors: Herbert B. Mayo

11th Edition

1285425790, 1285425795, 9781305464988 , 978-1285425795

More Books

Students also viewed these Finance questions

Question

Disordered eating in dance professionals

Answered: 1 week ago

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago