Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!


MKT 324

XL Data Analyst Assignment 1

You have the necessary XL Data Analyst Files and are now ready to complete this assignment. Also, you will be using this data in upcoming assignments, so please make sure you keep two copies of this data. Keep a set that in case one gets corrupted you can replace it with a clean file.

When you open the data files, you may see the following across the top of the page:

"Security Warning: Macros have been disabled" Enable Content

Go ahead and click on the Enable Content Button. This will allow you to use the Data Analyst software in conjunction with this data.

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 no later than Sunday 11:59 PM EST/EDT.

MKT 324
XL Data Analyst Assignment 1
You have the necessary XL Data Analyst Files and are now ready to complete this assignment. Also, you
will be using this data in upcoming assignments, so please make sure you keep two copies of this data.
Keep a set that in case one gets corrupted you can replace it with a clean file.
When you open the data files, you may see the following across the top of the page:
“Security Warning: Macros have been disabled” Enable Content
Go ahead and click on the Enable Content Button. This will allow you to use the Data Analyst software in
conjunction with this data.
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 no later
than Sunday 11:59 PM EST/EDT.

 


Solution details:
STATUS


ANSWER RATING

This question was answered on: Sep 05, 2019

Solution~000200247115.zip (25.37 KB)


This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
The publisher of your textbook offers an excellent daily news feed of newspaper articles on current events at the publisher’s website (Links to...
testimonials icon
Hi tutors, I have a range of tutorial exercise comprises of 3 exercises. I have done one of it but run out of time due to my job, please help me co...
testimonials icon
Physostigmine is a secondary metabolite produced by the African tropical vine Physostigma venosum, known as the calabar bean. This compound is used as...
testimonials icon
Answer the following questions thoroughly using exact passages from the text. (Seriously, if you don't actually quote specifi...
testimonials icon
. Describe the brand images the following “brands” have among students on your campus.  a. BlackBerry Smart Pho...
testimonials icon
NEED A PERFECT PAPER? PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:...
testimonials icon
Many examples of improvement projects conducted by health care organizations can be found on the Internet. Find an example of each type of project:...
testimonials icon
Describe the markets that are involved and the incentives that are used to encourage the development of medications. Research neglecte...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65