Learning Excel Assignment
docx
keyboard_arrow_up
School
Brigham Young University, Idaho *
*We aren’t endorsed by this school
Course
415
Subject
Statistics
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by MOls20003
Excel Assignment (10 points)
Part 1
Watch the posted videos on basic excel functions and graph building. Note: if you are already comfortable using excel, feel free to skip to part 2. Part 2 Open the excel spreadsheet and perform the following tasks. Once you have completed each task, copy and paste the data and/or graphs into this document to prove you have completed each
task. Do not submit the excel file on Canvas.
Task 1
: These data depict test scores on 5 tests for 9 subjects. Calculate the average, median, max, min, standard deviation, and variance for each of the 5 tests. Next, find the average score on the tests for each subject. Then, in one cell, calculate the following number for each subject: the average of test 1 and 2, the average of tests 3, 4 and 5, minus the square root of the average of the 5 tests (average of test 1 and 2 + average of tests 3,4,5 – sqrt of average of 5 tests). Lastly, create a bar graph depicting the mean and max for each of the 5 tests. There should be two bars for each test. Y1 should be the scores. The horizontal axis will be the 5 tests. Don’t forget to create a title, legend and axes labels. Copy and paste your actual data table showing calculations and the created graph into this word document. (2 points) 7
Excel Assignment (10 points)
Task 2
: These data depict height and weight for 10 different people. Height is in inches and weight is in pounds. Convert the height to meters and the weight to Newtons. Make a line graph showing these data. Put height in meters on Y1 and weight in Newtons on Y2. Subject name will
be your horizontal axis. Don’t forget to create a title, legend and axes labels with the appropriate units. Copy and paste your actual data table showing calculations and the created graph into this word document. (3 points) 7
Excel Assignment (10 points)
Task 3
: These data depict golf data. Two people hit golf balls using 5 different clubs. The horizontal distance traveled (in yards) for each club for each individual are given. In a bar graph, graph distance traveled on Y1 axis for the 5 difference clubs for each individual. The horizontal axis should be the subject name. Don’t forget to create a title, legend and axes labels with the appropriate units. Hint: the legend will list the types of club. Copy and paste created graph into this word document. (2 points)
7
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Excel Assignment (10 points)
Task 4
: These data depict standing long jump distances (in cm) between 3 different warm-up conditions (No warm up, dynamic warm up (Warm-up 1), and static stretch (Warm-up 2) for 3 subjects. Find the average of each warm-up condition, not the average jump distance for each subject. Use a line graph to display the data for each subject and the average (four lines total). Make the average line dark red. Choose different line colors for the 3 subjects. Bold all text. Y1 should be jump distance and the horizontal axis should be the warm up condition. Don’t forget to
create a title, legend and axes labels with the appropriate units. Copy and paste your actual data table showing calculations and the created graph into this word document. (3 points) 7
Related Documents
Related Questions
Describe the three primary charts and graphs used to organize and display data.
arrow_forward
* Question Completion Status:
QUESTION 1
Arnold purchased a $1,300 set of golf clubs on a nine-month layaway plan and had to pay a monthly payment of $158.89. What is the fee charged for the layaway plan?
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).
BIUS
Paragraph
Arial
14px
A
arrow_forward
could you provide an example please?
arrow_forward
4.
Find the domain and range of the given relation. State the domain and range as an
inequality. Select all that are true
The domain is {-5 ≤y<5}
The Range is {-4 ≤ x <2}
The domain is {-4 < x <2}
The domain is {-4 ≤ x ≤ 2}
The Range is {-5 ≤ y ≤ 5}
The Range is {-5
arrow_forward
Graph using tables of value
arrow_forward
Please show how to do this problem using excel, Show all of the formulas you use plese
arrow_forward
have a graphing calculater need help how to do it on calculater
arrow_forward
Just need help with part 3, thank you!
arrow_forward
Page
of 11
ZOOM +
5. The table shows how the cost of a carne asada taco at my favorite taco
stand has increased as they have become more popular since their
opening in 2013. Use the data to answer the questions below.
Year, x
2013, 0 2014, 1
2015, 2 2016, 3 2017, 4 2018, 5 2019,6
Cost ($) 0.50
0.55
0.65
0.75
0.90
1.00
1.10
(a) What is the regression line given by your TI-84 for this data?
Round values to 3 decimal places.
(b) Using the regression equation above, predict the cost of a carne asada
taco at my favorite taco stand in 2020. Show the work.
arrow_forward
Refer to image
arrow_forward
I need help, how can I make a spreadsheet on excel and input this so I can recreate this graph. I really dont understand how can someone be so kind to explain to me.
arrow_forward
how to organize information pictorially using charts or graphs?
arrow_forward
Thanks. How do you calculate this answer using the graphing calculator instead of Excel?
arrow_forward
Use a graphing utility to evaluate nPr
50P4
arrow_forward
If you don't mind, could you tell me which graphing software you used to do this and the input values you used? Thanks!
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Related Questions
- Describe the three primary charts and graphs used to organize and display data.arrow_forward* Question Completion Status: QUESTION 1 Arnold purchased a $1,300 set of golf clubs on a nine-month layaway plan and had to pay a monthly payment of $158.89. What is the fee charged for the layaway plan? For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph Arial 14px Aarrow_forwardcould you provide an example please?arrow_forward
- 4. Find the domain and range of the given relation. State the domain and range as an inequality. Select all that are true The domain is {-5 ≤y<5} The Range is {-4 ≤ x <2} The domain is {-4 < x <2} The domain is {-4 ≤ x ≤ 2} The Range is {-5 ≤ y ≤ 5} The Range is {-5arrow_forwardGraph using tables of valuearrow_forwardPlease show how to do this problem using excel, Show all of the formulas you use plesearrow_forwardhave a graphing calculater need help how to do it on calculaterarrow_forwardJust need help with part 3, thank you!arrow_forwardPage of 11 ZOOM + 5. The table shows how the cost of a carne asada taco at my favorite taco stand has increased as they have become more popular since their opening in 2013. Use the data to answer the questions below. Year, x 2013, 0 2014, 1 2015, 2 2016, 3 2017, 4 2018, 5 2019,6 Cost ($) 0.50 0.55 0.65 0.75 0.90 1.00 1.10 (a) What is the regression line given by your TI-84 for this data? Round values to 3 decimal places. (b) Using the regression equation above, predict the cost of a carne asada taco at my favorite taco stand in 2020. Show the work.arrow_forwardarrow_back_iosSEE MORE QUESTIONSarrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt

Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill

Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt