MKT 324 XL Data Analyst Assignment 1 You have the necessary XL Data Analyst Files and are now ready to assignment. Also, you will be using this data in upcoming assignments, so please make sure you ke
MKT 324 XL Data Analyst Assignment 1 You have the necessary XL Data Analyst Files and are now ready to 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.
Elitewriterhelp.com is an online academic writing site that provides a variety of services to students and professionals in need of essay, dissertation, and research paper assistance. This website was founded by experienced writers and editors who understand the needs of today’s student community. With their help, students can get a well-written paper without having to worry about the quality or accuracy of their content.
Elitewriterhelp.com offers a wide range of services that are designed to meet the needs of any student or professional looking for some extra help with their academic work. From simple editing services to complete custom writing pieces, they have something for everyone! Their team consists of highly qualified writers and editors who have years of experience in both academia and industry sectors across all fields such as English literature, nursing sciences, medical science, engineering design & technology, accounting & finance etc., making them one of the best providers around when it comes to providing quality content writing services.
When it comes to their custom writing service, Elitewriterhelp.com provides everything from essays & dissertations to research papers & lab reports; all written according to your exact specifications & requirements so that you can be sure your professor will be impressed with what you submit! They also provide formatting help which includes APA/MLA/Chicago style formatting for those stuck on tedious details like citations or bibliography entries; perfect for those last-minute assignments!
For those looking for proofreading & editing services instead; Elitewriterhelp.com has you covered too! The team at this website offer professional copyediting which can check grammar errors and spellings mistakes while still preserving your original voice within the text; ensuring that whatever piece you submit looks great while still sounding exactly how you want it do sound! What’s more is if required they can also provide advice on how best to improve certain parts in order make sure your work meets the criteria set by your professors so no marks are lost due to minor mistakes made in hurry or ignorance.
Last but not least is Elitewriterhelp’s paraphrasing service which helps take care off any plagiarism risks associated with submission an assignment where quotes are used extensively taken from sources outside class materials (eBooks etc.). The team will ensure that anything being submitted sounds fresh while leaving out any potential legal issues plaguing people using other authors works without proper permission given first when appropriate credit isn’t given otherwise – definitely something worth investing into before submitting examples cited within studies found elsewhere apart from class material sources only mentioned once during seminars etc..
To sum up: Elitewriterhelp offers students access top-notch custom writing pieces as well as editing/proofreading packages for existing ones already written – perfect for double checking against silly grammatical errors / typos overlooked during initial composition stages meaning there’s always hope even when running short on time ahead up coming deadlines looming near after long lectures spent inside classrooms sat away from laptops used mainly taking notes by hand easily misplaceable later down line afterwards rendering past efforts worthless sadly…
