A6: Spreadsheet Case Study
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
Pt1420 Unit 1 Assignment
1121 Words | 5 Pages1.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:
Fin 511 Final Exam
736 Words | 3 PagesSample 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
Summary Of Nicholas Carr's How Smartphones Hijack Our Minds?
1556 Words | 7 PagesIn 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.
Unit 312 Design And Produce Documents In A Business Environment
2058 Words | 9 PagesUnit 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.
Glg 101 Week 1 Assignment
1605 Words | 7 Pages11. 27. 35. Those arbitrary numbers remained in my head for an entire week. They were questions I knew I missed on my last test.
Biology: Photosynthesis And Respiration
593 Words | 3 PagesUse your results in Data Table 2 to support your answer.
Examples Of Persuasive Speech On Texting While Driving
1740 Words | 7 PagesName: 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:
Behavioral Intervention Case Study
488 Words | 2 PagesAfter 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.
Persuasive Speech: The Use Of Cell Phones While Driving
1089 Words | 5 PagesGeneral 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:
Nt1310 Unit 3 Data Analysis
1576 Words | 7 PagesComputers 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.
Positive Impacts: The Negative Impact Of Cell Phones
1012 Words | 5 PagesCell 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.
Informative Speech: The Effects Of Smartphone
835 Words | 4 PagesAccording 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
Use Of Mobile Phone In School
816 Words | 4 PagesHave 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?
How Smartphones Affect Society
782 Words | 4 PagesThese 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.
More about A6: Spreadsheet Case Study
Pt1420 Unit 1 Assignment
1121 Words | 5 PagesFin 511 Final Exam
736 Words | 3 PagesCyp 3.5 Psy/270
984 Words | 4 PagesSummary Of Nicholas Carr's How Smartphones Hijack Our Minds?
1556 Words | 7 PagesUnit 312 Design And Produce Documents In A Business Environment
2058 Words | 9 PagesGlg 101 Week 1 Assignment
1605 Words | 7 PagesBiology: Photosynthesis And Respiration
593 Words | 3 PagesExamples Of Persuasive Speech On Texting While Driving
1740 Words | 7 PagesBehavioral Intervention Case Study
488 Words | 2 PagesPersuasive Speech: The Use Of Cell Phones While Driving
1089 Words | 5 PagesNt1310 Unit 3 Data Analysis
1576 Words | 7 PagesPositive Impacts: The Negative Impact Of Cell Phones
1012 Words | 5 PagesInformative Speech: The Effects Of Smartphone
835 Words | 4 PagesUse Of Mobile Phone In School
816 Words | 4 PagesHow Smartphones Affect Society
782 Words | 4 Pages