ipl-logo

A6: Spreadsheet Case Study

820 Words4 Pages

BETTY CELL-PHONE USUAGE

A6: Spreadsheet Summative

1. How many months did Betty exceed the average?
In terms of Betty Smith of the exceeding average for her cell-phone usage, she has numerous times. For instance, for cell phone usage for calls (in minutes) in a 12-month period, she has exceeded the average 3 times during May, June, and July. Where for cell-phone usage for text messages, in a 12 month period she has exceeded the average twelve times. Finally, for cell-phone usage for data (in megabytes) in a 12 month period, she has exceeded the average over six times.
2. Which representation was the most useful? The excel bar graph or the numbers on the spreadsheet? Why?
In our professional opinion, the most useful way to represent …show more content…

What is the average number of minutes Betty used on cell phone calls?
The average amount of cell-phone usage for calls Betty Smith has used throughout the 12 month period was 230.4166667 (in minutes).

4. What is the average number of text messages that Betty used?
The average amount of text messages that Betty Smith has used throughout the 12 month period was 1052.833333 messages.
5. What is the average amount of data in MB that Betty used?
The average amount of data that Betty Smith has used throughout the 12 month period was 676 (in megabytes).
6. What is the yearly total for the minutes used texts and data used in …show more content…

What is a logical explanation for what you see in the usage throughout the year?
Throughout the year, especially during the time for school from the months of September to June, Betty Smith seemed to use less form the 3 cell-phone features, with an average of 1045.1. Where, from the month of July to September, the average total for the 3 cell-phone features, it was 1200.8. Also, in terms of the times of vacations, around the months of December and march, Betty has had the highest numbers of all the cell-phone features. A logical explanation for the trend represented, that during the holiday, in which she might have spare time, she uses the most features for her cell-phone plan. In which explains, the reasons for a high cell-phone usage for texting, calling and data.
9. Find the three highest text message months in your bar graph and put a 0 in the spreadsheet for those 3 months (exclude them).
Complete.
10. What changes does this cause in the

Show More
Related

Pt1420 Unit 1 Assignment

1121 Words | 5 Pages

1.1.2 Graphs We have now converted information from words or pictures to tables to formulae and now we’re going to look at how we can convert information into graphs: Example: If we invest R1 and it doubles every month, how much will we have at the end of 1 year? Let’s first draw a table: Months 1 2 3 4 5 6 7 8 9 10 11 12 Rands 1 2 4 8 16 32 64 128 256 512 1024 2048 Now let’s depict this information as a graph or chart: We can draw a bar chart:

Read More

Fin 511 Final Exam

736 Words | 3 Pages

Sample questions for midterm 1. In a skewed distribution, which of the following values is most likely to be dragged toward the longer tail of the distribution? a) the mean b) the mode c) the median d) none of the above 2. Which of the following RFM codes represents a potentially very valuable customer who hasn’t bought recently and should be encouraged to order? a) 511 b) 111 c) 151 d) 115

Read More

Cyp 3.5 Psy/270

984 Words | 4 Pages

37 5. 18 6. 15 7.

Read More

Biology: Photosynthesis And Respiration

593 Words | 3 Pages

Use your results in Data Table 2 to support your answer.

Read More

Unit 312 Design And Produce Documents In A Business Environment

2058 Words | 9 Pages

Unit 312 Design and Produce Documents in a Business Environment 1. Understand the purpose and value of designing and producing high quality and attractive documents. 1.1 Describe different types of documents that may be designed and produced and the different styles that could be used. There are lots of different types of document that can be produced in a business environment, e.g. agendas, minutes, spreadsheets, letters, presentations, business cards, charts etc. Agendas - An agenda is a list of what should happen in a meetings, generally in the in the order in which they are to be taken up.

Read More

Glg 101 Week 1 Assignment

1605 Words | 7 Pages

11. 27. 35. Those arbitrary numbers remained in my head for an entire week. They were questions I knew I missed on my last test.

Read More

Behavioral Intervention Case Study

488 Words | 2 Pages

After observing the clients behavior, it is evident that she has a problem limiting her excessive cellular device usage. Therefore, the behavioral intervention plan will be targeting the client’s cellular device usage in class, as well as outside of class. The plan will be targeting all cellular device usage, which includes playing games, texting, scrolling though social media sites, and finally listening to music. To prevent the client from using her phone during lectures, the behavioral plan instructed her professors to make her write an essay whenever she is using her phone.

Read More

Examples Of Persuasive Speech On Texting While Driving

1740 Words | 7 Pages

Name: Davon Dower Date: April 15, 2015 Persuasive Speech Title: Texting While Driving General Purpose: to persuade Specific Purpose: To convince the audience that driving is a serious matter and it could cause risk Proposition Statement: I want to convince you all to start focusing more on driving then texting, because it can wait. INTRODUCTION: I. Attention Getter:

Read More

Summary Of Nicholas Carr's How Smartphones Hijack Our Minds?

1556 Words | 7 Pages

In Nicholas Carr’s article, “How Smartphones Hijack Our Minds” (November 10, 2017) Carr discusses the implications of allowing our smartphones to have such a huge effect on our lives. Smartphones serve many purposes, and have created massive societal effects throughout the world despite being introduced roughly only two decades ago. One can converse with anyone in the world at any given moment, they can watch any television show they want, and they can receive alerts so they no longer have to put effort into remembering things themselves. However, with so much control over people’s own lives, one begins to wonder about the negative consequences of the smartphones themselves.

Read More

Persuasive Speech: The Use Of Cell Phones While Driving

1089 Words | 5 Pages

General purpose: to persuade Specific purpose: to persuade my audience that the use of cellphone while driving has become a life threatening not only to the driver but also to other motorist and pedestrians. Thesis: Preview: -To discuss on how we can decrease the percentage of those who use their cell phone while driving. - To discuss the cons and the outcome of the use of cell phone while driving. A. Attention getter:

Read More

Positive Impacts: The Negative Impact Of Cell Phones

1012 Words | 5 Pages

Cell Phones and Their Negative Impact Every day 6.8 billion people use a cell phone. With almost 91% of the world population using these devices, one would assume they are safe. They are not. Some would disagree, contradicting with how cell phones can improve your everyday life with health apps, reminders, etc.

Read More

Nt1310 Unit 3 Data Analysis

1576 Words | 7 Pages

Computers permit large amounts of data to be stored, either on the computer's hard disk or in portable diskettes. Data Manipulation and Processing Data manipulation and processing are performed to obtain useful information from data previously entered into the system. Data manipulation embraces two types of operations: operations needed to remove errors and update current data sets and operations using analytical techniques to answer specific questions formulated by the user. The manipulation process can range from the simple overlay of two or more maps to a complex extraction of disparate pieces of information from a wide variety of sources. Data Output Data output refers to the display or presentation of data employing commonly used output formats that include maps, graphs, reports, tables, and charts, either as a hard-copy, as an image on the screen, or as a text file that can be carried into other software programs for further analysis.

Read More

Use Of Mobile Phone In School

816 Words | 4 Pages

Have you ever think about the effect allowing students using phone in school? B. General Statement: mobile phone is such a wonderful tool for communication, education, work, information and somehow we wonder how we survived before this. By looking at its benefit, do you allowing students using handphone in school? How much it will effect student’s life?

Read More

How Smartphones Affect Society

782 Words | 4 Pages

These devices are always in people's pockets. People spend most of their time with the phone. A typical day of a smartphone user is as follows: wakes up and checks their phone. During meals, they are using their smartphone. At school, their face is buried in the cell phone.

Read More

Informative Speech: The Effects Of Smartphone

835 Words | 4 Pages

According to Gordon Pennycook (2015) state that "those who think more intuitively and less analytically when given reasoning problems were more likely to rely on their Smartphones for information in their everyday lives." 2. In fact, the funtion of the smartphone is to help us record the contact number so

Read More

More about A6: Spreadsheet Case Study

Related Topics

Open Document