Question: pls help me create 2 line graphs for this data in excel We conducted an experiment where the participants were required to remember 9 syllabuses

pls help me create 2 line graphs for this data in excel

We conducted an experiment where the participants were required to remember 9 syllabuses three times. There were 12 trials with distractions between sets and 15 trials without distractions. I need two line graphs, one showing the results with distractions and the other without distractions. Each graph should have three lines representing the three sets that were conducted. Therefore, when you check the documentation under their name, you will find three attempts to remember all nine syllabuses. title: Average Memory Retention with Distraction

Average Memory Retention without Distraction

With distraction

  1. Gene

Remembered 8

Remembered all 9

Remembered all 9

2)La

Remembered 7

Remembered 6

Remembered 6

3)Janine

Remembered 1

Remembered 1

Remembered 1

4)Raiza:

Remembered 9

Remembered 9

Remembered 8

5) Mahiro

Remembered 7

Remembered 6

Remembered 8

6)Alex

Remembered 9

Remembered 9

Remembered 7

7)Lori

Remembered 9

Remembered 9

Remembered 9

8) Faith

Remembered 9

Remembered 9

Remembered 9

9) Jarah

Remembered 9

Remembered 8

Remembered 8

10) Candi

Remembered 9

Remembered 9

Remembered 9

11) Alika

Remembered 9

Remembered 9

Remembered 9

12) Pauline

Remembered7

Remembered 9

Remembered 9

Without distraction

1. Gaea

Remembered 9

Remembered 8

Remembered 8

2. Monique

Remembered 9

Remembered 9

Remembered 9

3. Faith

Remembered 9

Remembered 9

Remembered 9

4. Lean

Remembered 9

Remembered 9

Remembered 9

5. Iya

Remembered 7

Remembered 8

Remembered 7

6. Fiona

Remembered 1

Remembered 1

Remembered 1

7. Jane

Remembered 8

Remembered 7

Remembered 9

8. Julia

Remembered 9

Remembered 9

Remembered 9

9. Jam

Remembered 8

Remembered 9

Remembered 9

10.Isa

Remembered 9

Remembered 9

Remembered 7

11.Sam

Remembered 8

Remembered 7

Remembered 7

12. Ella

Remembered 8

Remembered 7

Remembered 7

13. Pat

Remembered 9

Remembered 9

Remembered 6

14. Rachel

Remembered 7

Remembered 7

Remembered 7

15. Yvonne

Remembered 9

Remembered 9

Remembered 9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!