Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Exercise: 1. Use the questioner paper to collect 35 different data. For every question, you can check the screenshot to see how your answer should

image text in transcribed

Exercise: 1. Use the questioner paper to collect 35 different data. For every question, you can check the screenshot to see how your answer should look, but do not use the same names and values. 2. Create a new Excel Workbook and fill in the data in sheetl and rename it "Customer Data". Monthly Monthly Monthly Megabytes phone bill internet cost income spent 125 Mobile Age Gender operator system 301F ANDROID 34M IOS 50M ANDROID 3817 ANDROID 401F IOS IOS 30 F IOS 33 M ANDROID 28 F IOS 29M WINDOWS 25 $ $ $ $ $ $ $ $ $ $ 70.00 $ 170.00 $ 166.00 S 300.00 $ 59.00 $ 50.00 $ 155.00 $ 482.00 S 431.00$ 55.00 $ 15.00 $2,000.00 45.00 $ 700.00 55.00 $1,000.00 66.00 $5,000.00 89.00 $6,500.00 100.00 $1,200.00 55.00 $ 700.00 67.00 $ 600.00 88.00 $ 500.00 90.00 $ 800.00 375 458 550 742 833 458 558 733 750 3. Add a new column and name it "Megabytes spent, and write a function that gives the number of Megabytes spent if the cost per megabyte is 0.128. 4. On a new sheet named "Statistics", write the appropriate functions that give you the following: i. Number of customers ii. Percentage of customers using IOS operating system under the age of 30 iii. Percentage of customers using Android operating system and having a monthly phone bill less than 100$ iv. Percentage of customers using Windows operating system and having a monthly income between 1000$ and 2000$ v. Average monthly income for each gender

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_2

Step: 3

blur-text-image_3

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

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

3. Is IBMs program really a mentoring program? Why or why not?

Answered: 1 week ago