Business > Research Paper > Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3 (All)

Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3

Document Content and Description Below

Task 1 A supermarket manager wanted to investigate the profile of shoppers resistant to the use of self-checkout counters available at the store he manages and to find out the reasons behind their ... resistance. He asks three of his staff to conduct a survey among customers using the store in Sheffield Hallam area during a quiet working day in October of 2019 as they exited the store. The short questionnaire used for the survey as well as the data collected can be found on an Excel file named “SCC”. There are two worksheet, one for the questionnaire used and the other worksheet for the raw data collected from the customers. The data worksheet has 18 columns. Column A “Customer” is simply a column to identify the customer surveyed – Customer 1, Customer 2 etc… Each of the other 17 columns refer to a question – Column B refers to the gender question, Column C refers to the age question etc… The manager has employed you as data analyst to conduct this investigation. Your analysis should use the statistical facilities on Excel as required below. Required: 1. Label the codes for the categories of the following variables: • Gender • Age • Education • Are you a regular user of self-checkout user Note to students: There are FOUR tasks and you are expected to complete all of them. You are required to transfer the work of all tasks on to a single wordprocessed MS Word file and upload it on Turnitin, which is the submission of this assignment. The deadline for this assignment is 2. Produce frequency and percentage frequency tables for each of the following variables: • Gender • Education • Age • SCC user • Spending (£) For this last quantitative variable, the categories should be as follows: <100 100- 109 110- 119 120- 129 130- 140 >140 3. Draw the graphical representation for each of the following variables: • Education (Pie chart) • Age (Bar chart) • Spending (Histogram) using the following categories: <100 100- 109 110- 119 120- 129 130- 140 >140 • Spending (Box and whisker) graph 4. Consider now the variable “Spending (£)”. • Calculate the minimum, maximum, median, quartiles and the mean average statistics. • Calculate the mean and standard deviation” split by users (and non-users) of SCC. 5. Produce a cross-table between each of the following two variables and draw an appropriate multiple bar chart: • Are you a regular user of self-checkout user and Gender • Are you a regular user of self-checkout user and Age 6. Draw a scatter diagram and calculate the correlation coefficient of Spending against the reliability total score. [Show More]

Last updated: 1 year ago

Preview 1 out of 5 pages

Reviews( 2 )

user-profile-pic


by eddiebutnaru · 2 years ago

not at this time :)

Hey, thanks for the review. if you also wish to get more quality documents at very cheap prices here is my email [email protected], would you also share with me your email for direct requests. thankyou by Expert Tutor. 2 years ago

user-profile-pic


by Expert Tutor · 2 years ago

Hey, thanks for the review. if you also wish to get more quality documents at very cheap prices here is my email [email protected], would you also share with me your email for direct requests. thankyou

Recommended For You

 Business> Research Paper > QA BA3020QA UMD Assignment 3 - Nov 2020 Thompson Rivers University - BA 3020 Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3 (All)

preview
QA BA3020QA UMD Assignment 3 - Nov 2020 Thompson Rivers University - BA 3020 Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3

Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3 Task 1 A supermarket manager wanted to investigate the profile of shoppers resistant to the use of sel f-chec...

By Tutor Frankline , Uploaded: Jul 20, 2021

$10

 Business> Research Paper > USING AND MANAGING DATA AND INFORMATION APRIL (2019 – 2020), LATEST RESEARCH AND ASSIGNMENT PAPER (All)

preview
USING AND MANAGING DATA AND INFORMATION APRIL (2019 – 2020), LATEST RESEARCH AND ASSIGNMENT PAPER

USING AND MANAGING DATA AND INFORMATION APRIL (2019 – 2020), LATEST RESEARCH AND ASSIGNMENT PAPER USING AND MANAGING DATA AND INFORMATION APRIL (2019 – 2020), LATEST RESEARCH AND ASSIGNMENT PAPERUSIN...

By Quizmaster001 , Uploaded: Apr 16, 2021

$10

 Business> Research Paper > QA BA3020QA UMD Assignment 3 - Nov 2020 Thompson Rivers University - BA 3020 Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3 (All)

preview
QA BA3020QA UMD Assignment 3 - Nov 2020 Thompson Rivers University - BA 3020 Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3

Using and Managing Data and Information April cohort (2019 – 2020) BA3020QA - Assignment 3 Task 1 A supermarket manager wanted to investigate the profile of shoppers resistant to the use of self-...

By Muchiri , Uploaded: Mar 24, 2021

$11

 *NURSING> Research Paper > BSN C493 Portfolio WGU - Western Governors University (All)

preview
BSN C493 Portfolio WGU - Western Governors University

BSN C493 Portfolio WGU - Western Governors University This portfolio represents my professional nursing growth. Western Governor university prepared me to advance my education professionally. Th...

By SuperSolutions© , Uploaded: Nov 23, 2020

$12

 *NURSING> Research Paper > Risk factors for diabetes (All)

preview
Risk factors for diabetes

This document is an informative and comprehensive piece providing a detailed overview of the risk factors associated with diabetes. It covers both type 1 and type 2 diabetes, delving into the various...

By Elly , Uploaded: Jul 27, 2023

$6.5

 *NURSING> Research Paper > NURSING NR 439 Evidence Based Practice: Research Article Critique. (All)

preview
NURSING NR 439 Evidence Based Practice: Research Article Critique.

NR 439: Evidence-Based Practice >Research Article Critique.

By Academia1434 , Uploaded: Jul 11, 2020

$10.5

 Programming> Research Paper > Computer Science Engineering & Technology Java Programming. Weather Generator (40 points) (All)

preview
Computer Science Engineering & Technology Java Programming. Weather Generator (40 points)

Computer Science Engineering & Technology Java Programming Question 3. Weather Generator (40 points) Overview A weather generator produces a "synthetic" time series of weather data for a locati...

By QuizMaster , Uploaded: Mar 20, 2021

$10.5

 Business> Research Paper > BUS 600 WEEK 6 FINAL RESEARCH PAPER (All)

preview
BUS 600 WEEK 6 FINAL RESEARCH PAPER

Research Paper Focus of the Research Paper The Research Paper will be a comprehensive research review of the significant principles of management communications used to successfully achieve or...

By ACADEMICTUTORIAL , Uploaded: Dec 03, 2020

$3.5

 *NURSING> Research Paper > Interdisciplinary Paper (All)

preview
Interdisciplinary Paper

Research paper Incorporate health outcomes of the health promotion, detection of disease and disease prevention. Organize an interdisciplinary paper for your client and the delivery of safe a...

By ACADEMICTUTORIAL , Uploaded: Apr 04, 2021

$3

 Management> Research Paper > WEEK 15 Research Paper Enterprise Risk Management (All)

preview
WEEK 15 Research Paper Enterprise Risk Management

Risk management is one of the most important components in empowering an organization to achieve its ultimate vision. With proper risk management culture a nd knowledge, team members will be “speaking...

By ACADEMICTUTORIAL , Uploaded: Sep 04, 2021

$4

$7.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
217
2

Document information


Connected school, study & course



About the document


Uploaded On

Apr 07, 2021

Number of pages

5

Written in

Seller


seller-icon
Expert Tutor

Member since 3 years

55 Documents Sold


Additional information

This document has been written for:

Uploaded

Apr 07, 2021

Downloads

 2

Views

 217

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

custom preview

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

custom preview

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·