Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-806751%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806751%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20haven't%20used%20Excel%20in%20the%20way%20I%20need%20to%20know%20and%20I%20could%20use%20some%20assistance.%20I%20have%20to%20do%20a%20correlation%20between%20the%20beginning%20of%20the%20school%20year%20and%20the%20end%20of%20the%20school%20year%20with%20including%20attendance.%20Trying%20to%20show%20that%20the%20more%20you%20attend%20the%20more%20successful%20children%20are%20at%20the%20end%20of%20the%20year.%20I%20truly%20don't%20have%20an%20idea%20on%20how%20to%20show%20this%20but%20I%20was%20told%20to%20use%20excel%20to%20create%20this%20piece.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20could%20help%20that%20would%20be%20great!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-806751%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-806764%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-806764%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392937%22%20target%3D%22_blank%22%3E%40alex21865%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%2C%20if%20you%20have%20an%20attendance%20rate%20for%20each%20person%20during%20the%20year%20(e.g.%20in%20%25)%20and%20how%20the%20average%20rank%20is%20increased%20for%20the%20same%20year%2C%20you%20may%20plot%20scatter%20chart%20against%20these%20data%20to%20show%20dependence.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-807256%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-807256%22%20slang%3D%22en-US%22%3E%3CP%3Eokay%20so...%E2%80%A6%20how%20do%20I%20do%20this%3F%20I%20have%20there%20attendance%2C%20the%20beginning%20of%20the%20year%20performance%20and%20the%20end%20of%20the%20year%20in%20percent%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809463%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809463%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392937%22%20target%3D%22_blank%22%3E%40alex21865%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20734px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127340i7DF3F1B1A137F94D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ewith%20random%20numbers%20for%20attendance%20and%20performance.%20You%20may%20plot%20scatter%20chart%20on%20these%20two%20columns%20adding%20names%20as%20labels.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hey guys,

 

So I haven't used Excel in the way I need to know and I could use some assistance. I have to do a correlation between the beginning of the school year and the end of the school year with including attendance. Trying to show that the more you attend the more successful children are at the end of the year. I truly don't have an idea on how to show this but I was told to use excel to create this piece. 

 

If anyone could help that would be great!!

 

Thanks

3 Replies
Highlighted

@alex21865 

As variant, if you have an attendance rate for each person during the year (e.g. in %) and how the average rank is increased for the same year, you may plot scatter chart against these data to show dependence. 

Highlighted

okay so...… how do I do this? I have there attendance, the beginning of the year performance and the end of the year in percent @Sergei Baklan 

Highlighted

@alex21865 

It looks like

image.png

with random numbers for attendance and performance. You may plot scatter chart on these two columns adding names as labels.