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
alex21865
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

@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. 

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 

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies