Scribd
Upload
157 views5 pages

Trend Lines Case Study

Uploaded by

alidorkandolo509
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
157 views5 pages

Trend Lines Case Study

Uploaded by

alidorkandolo509
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Trend Lines Case Study

To complete this Case Study, you will need to have this document AND the Trend Line Study
Excel Document open. Please remember that you are not permitted to use AI for this
assignment.
Project Goal: To learn how trend lines can be used as a powerful tool in the Quantitative
Reasoning Process.

1. Understand the Problem


To start, choose a situation that can be analyzed using a scatterplot and trend line. The scenario
should involve numerical (quantitative data) that allows the relationship between an input
variable and an output variable to be displayed on a scatterplot with a trend line. You can refer
to the examples below for inspiration, but it's recommended that you select a scenario that is
relevant to your experiences. Try to be creative when choosing your scenario, and make sure
it's something that will allow you to make an informed decision based on the data you collect
and analyze.
Below are scenario ideas:
● Personal Health: Compare the number of steps you take each day and the hours you
sleep at night.
● Buying a Laptop: Compare the processor speed and the cost of a laptop.
● COVID-19: Compare the average age of people in a city or country and COVID rates.
● Running: Compare the age of a runner to their speed.
● Education: Compare the number of hours spent studying and the grades received in a
course.
● Economics: Compare the unemployment rate and inflation rate in a country.
● Mental Health: Compare the level of stress and the number of hours of sleep a person
gets.
● Grocery Shopping: Compare the cost and nutritional value of different brands of food
items.
● Higher Education: Compare the cost and potential earnings of different degree
programs or vocational training.
Here are a few places to check online if you need free data:
● Google Public Data
● The World Factbook
● OpenCorporates
● Kaggle Datasets
● FiveThirtyEight

Question Answer
Describe the background and purpose of My dad has been selling phones as a
your scenario. businessman since 2000. He earns a good
profit each year based on the total number
ofphones he sells. I am interested in
understanding the customer demand each
year and creating a trend line to predict the
number of phone sales from 2000 to 2025

2. Identifying Variables and Assumptions


List the important factors and conditions that you will consider when making your decision. You
will need to identify two main variables:
● An input variable that affects the outcome
● An output variable
Additionally, you should mention two or more key assumptions. Assumptions refer to the
known conditions of the comparison, and they are not predictions or hypotheses. They are like
the "controls" in a scientific experiment.

Question Answer

List your input and output variables. Input variable: Years.


Hint: A variable is an element of a situation Output variable: Phone Sold.
that has the potential to vary or change in
value.

List two or more key assumptions for this 1.I was confident that customer demand
problem. wasconsistently increasing each year.
Hint: Assumptions are ideas or concepts that 2. I was convinced that this year's sales
are accepted as true. Assumptions are like would surpass last year's.
removing the "what ifs" in a scenario. 3. I was certain that my dad had achieved
greater profits.

3. Apply Quantitative Tools


Gather data and report on your findings by following these steps:
1. Gather at least 15 numerical data points. Either collect the data on your own or find the
data online from a reliable source. Put the data on the Excel spreadsheet. (Green and
yellow boxes)
2. Explain how you collected the data.

Question Answer

What is the source(s) of your data? This data was collected from my dad's
phone company.

How did you collect your data? I compile all the records he has made
from 2000 to 2024 in his archive.

3. Create a scatterplot on the Excel spreadsheet. (Pink box)


a. Include a main title and axis titles.
b. Add an appropriate trend line to the graph to help you make your informed
decision.
4. State which trend line best fits your data and record the equation for the trend line you
selected.

Question Answer

Was your trend line of best fit linear, My trend line was Linear.
exponential, or quadratic?

Record the equation for the trend line Equation: y = 117.58x - 234206
you selected.

4. Make an Informed Decision


Use the scatterplot and trend line from Step 3 to make your decision. Write about your decision
and include a prediction using the trend line equation. Make sure your decision is supported by
your data and trend line.
In Excel use your trend line equation to calculate your prediction. (Blue boxes)
● Your input value (x): Put your input value in the blue box in Excel.
● Use your equation to calculate your prediction here.: Plug your own input value (x) into
your trendline equation to make a relevant prediction.

Question Answer

Write a short paragraph (4-5 sentences) that During 2000 and 2001, phone sales were at
explains your decision. Support your decision their lowest due to my dad being new in the
using your data and trend line prediction. business and having fewer customers.
However, since 2015, there has been a
significant improvement, and my dad has
been able to generate more profit by
attracting good potential customers.

5. Evaluate Your Reasoning


Share your project and data with at least two other people, such as group members on the
discussion board, an online tutor, family member, or friend. Ask for feedback from them and
use it to improve your project. After incorporating the feedback, answer the questions below
about the feedback you received and explain any changes you made to your project because of
their evaluation. This completes the Quantitative Reasoning Process.

Question Answer

Who did you share your project with? Name 1: Agatha Okofu
Name 2: Stanley Okai
How you know these people: All of them are
my online friends at BYU-I

What feedback did you receive? They both pointed out that my prediction
was consistently too high for all the years the
phones were sold.

What changes did you make because of the I used a prediction equation to calculate the
feedback you received? total number of phones sold, and my
prediction was moderately adjusted

Authenticity Check
Question Answer

Did you use AI to complete this assignment? No, I didn't use Al to complete this
If so, please redo the assignment without assignment.
using AI before submitting it.

Turning in Your Assignment


1. Make sure all the answer boxes are filled in on this document.
2. Make sure all the colored boxes in the Excel spreadsheet are completed.
3. Review the rubric before you turn in this assignment to make sure you will get the best
grade possible for your work.
4. Turn in both this document and the Excel spreadsheet.

You might also like