Need this out in excel and also word please. Weighting: 30% of the mark for this assignment.
In this part of the TMA you will be given some data and asked to use these to make a graph in Excel (or alternative software). The type of graph you should produce is a bar chart. Once you have created the graph, you are asked to describe what the data show. You are not asked to try to interpret the data beyond what the graph demonstrates.
Data for the graph Imagine that you have been asked by a local police force to conduct some research looking at the number of police lineups in the first half of the year. The data is hypothetically the number of police lineups that were administered over the first 6 months of the year. The police are interested in whether there are certain times of the year where they might need more staff to be at the station to ensure there is someone to conduct the police lineup.
Month January February March April May June Number of police lineups 40 97 152 160 136 164
Using the data in the table, make a graph in Excel (or equivalent software). Then place the graph into a Word (or similar) document, give the graph a meaningful title and describe what the data represent underneath.
You do not have a word count for this part of the task, but it should not take you many words. You need to describe what the graph shows, but you do not have to explain why there might be different numbers of lineups at certain times of the year.
In the ‘Student notes for Part B’ section you can find more detail on how to approach this part of the assessment, including links to relevant material.
Instagram Growth & Engagement Strategist Category: Content Creation, Content Marketing, Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Social Media Management, Social Media Marketing, Twitter Budget: $10 - $30 USD
18-Aug-2025 16:01 GMT
Odoo Install on Google Cloud Category: Cloud Computing, Debian, Linux, Odoo, Python, System Admin, System Administration, Ubuntu Budget: $10 - $30 USD
18-Aug-2025 16:01 GMT
Engaging Social Media Content Pack Category: Photoshop, Content Creation, Copywriting, Graphic Design, Illustration, Photoshop Design, Social Media Management, Social Media Marketing, Video Editing Budget: £10 - £200 GBP
18-Aug-2025 16:00 GMT
Friendly Food & Kitchen Blog Articles Category: Article Writing, Blog, Blog Writing, Content Writing, Creative Writing, Ghostwriting, Research, SEO Writing Budget: $250 - $750 AUD
18-Aug-2025 16:00 GMT
MySQL Data Cleaning Specialist Category: Data Analysis, Data Entry, Data Management, Data Processing, Database Administration, Database Programming, MySQL, PHP, Python Budget: ₹1500 - ₹12500 INR
18-Aug-2025 16:00 GMT
Retro Radio Logo Design Category: Adobe Illustrator, Branding, Creative Design, Graphic Design, Illustration, Logo Design, Photoshop Budget: $10 - $30 USD
18-Aug-2025 15:58 GMT
Logo to DXF Conversion Category: 2D Drafting, 3D Design, 3D Modelling, 3D Rendering, AutoCAD, CAD / CAM, Graphic Design, Solidworks Budget: $10 - $30 USD
18-Aug-2025 15:57 GMT
Technical SEO for Product Pages Category: Internet Marketing, Link Building, Marketing, Search Engine Marketing (SEM), SEO, SEO Auditing, Website Analytics, Website Optimization Budget: $30 - $250 USD
Virtual Assistant Needed for Simple Tasks Category: Admin Support, Customer Service, Customer Support, Data Entry, Data Management, Excel, Typing, Virtual Assistant Budget: ₹12500 - ₹37500 INR
18-Aug-2025 15:56 GMT
Business Startup Blueprint Category: Business Analysis, Business Consulting, Business Development, Business Plan Writing, Business Plans, Market Research, Marketing, Marketing Strategy Budget: min $100000 USD
