Question

HELP needed urgently....Data and question is attacted below..... Thank you in advance

there is no data link fir this data it’s all in photos.... thank you

i have already posted the question

Answer 1

H55 Max Min.xlsx - Excel Reysollan Sivasankar CMB QES File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share to SmartArt Screenshot Get Addins π Ω - TH Pivot Chart I? Recommended Charts My Add-ins - S 3D Map - Tours Slicer Timeline Link 4 WordArt Signature Line- Text Header Box & Footer Object Text Line Column Winy Loss Speridines Equation Symbol Add-ins Charts Filter: Link Symbols н I ] K L M N O P R S 1 12 Pivot Table Recommended Table Pictures Online Shapes Prolables Pictures Tables Ilustrations Pivot Table f No. Fasily arrange and summarize complex data in a Pivottable. D FYI: You can double-click n value to STPM See which detailed values make up STPM the summarized total Diploma 2 Tell me more STPM 370 raut remale STPM 378 377 Math Female Matrculation 379 378 Stat Female Matrculation 380 379 Stat Male STAM 381 380 Stat Male STPM 382 381 Stat Female STPM 383 382 Stat Female STPM 384 383 Stat Male STPM 384 Stat Female Others 389 Stat Female STPM 387 386 Stat Female Diploma 388 387 Stat Female STPM 389 388 Stat Female STPM 390 389 Stat Male Others 391 390 Stat Male Diploma 392 391 Stat Female Matrculation 393 392 Stat Female STAM 394 393 Stat Male Matrculation 395 394 Stat Female Diploma 396 395 Stat Female STPM 397 396 Stat Female STPM 398 397 Stat Female STPM 399 398 Stat Female STPM 400 399 Stat Female STPM 401 400 Stat Female STPM Sheet1 Sheet2 Sheet3 + Ready E Private Private Public Public Public Private Public Public Private Own Private Private Public Private Private Private Private Private Public Public Own Public Public Private Public Private Private Private Private 365 386 F F Executive Executive Executive Executive Executive Executive Executive Miscellaneous Executive Director Executive Executive Executive Executive Executive Executive Executive Executive Executive Executive Director Teacher Teacher Executive Executive Lecturer Executive Executive Executive G 10000 7900 5400 3200 4000 8900 2800 1600 9400 9600 7100 6600 2400 7800 9600 5600 7200 5800 3400 3700 10500 2800 5100 7500 3200 6000 9100 8000 7200 Average 3/41.925 Count: 2807 Min 1 Mac 12300 Sum: 2993540 # - + 100% 13:10 El e T A4) D ENG 18-05-2020

Max Minxlsx Excel Reysollan Sivasankar CMB QES File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share A SmartArt Screenshot DE Get Add in 4 WordArt Signature Line π Ω My Acid-ins - 2 Recommended Charts Pivot Chart Slicer Timeline Pivot Table Recommended Table Pivotlables Table: Header Object Pictures Online Shapes Pictures Ilustrations Equation Symbol 3D Map Tours Text Header Boy & Footer Line Column Winy LOSS Speridines Add-ins Charts Filter: Link Text Symbols A1 X No, I 7 н X ] Create Pivot Table K L S TA A No. Chuse the data that you want to analyze Select ble orange Iob c/Range: Sheet3:54$1:$65401 be an extemaldata source Choose Connection. Connection name Use this workbook's Del Model Chocce where you want the Portable report to be placed New Worchest Existing Worksheet Location: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 2 B с D E F G Program Gender Essential Qualification Working Sector Level of Work Salary Deesc Male Matrculation Public Executive 200 Desc Female STAM Own Director 12000 DecSc Female Matrculation Public Teacher 4300 Female Diploma Public Executive 6000 DecSc Female STPM Private Executive 9000 DecSc Female STPM Public Executive 4700 DecSc Male STPM Private Lecturer 7500 DecSc Male STPM Private Executive 10600 DecSc Female STPM Own Director 11500 DecSc Female STPM Own Director 11000 DecSc Male STPM Private Executive 8500 DecSc Female Diploma Public Executive 6000 DecSc Female STPM Public Executive 3800 DecSc Female STPM Public Executive 5400 DeeSe Female Matrculation Private Executive 10300 Decsc Female Matrculation Public Executive 4200 DecSc Male STAM Public Miscellaneous 3000 Decse Male STPM Private Executive 10800 Female STPM Own Director 11000 DecSc Female STPM Private Executive 8500 DecSc Male STPM Private Executive 8000 DecSc Female Others Public Executive 3800 DecSc Female STPM Private Executive 9200 DecSc Female Diploma Private Executive 11000 Decsc Female STPM Private Executive 7000 DecSc Female STPM Private Executive 8600 DecSc Male Others Private Executive 7200 DecSc Male Diploma Public Executive 4800 Maece Camsial MashAR Dublin Cuctive Einn Sheet1 Sheet2 Sheet3 2 3 4 5 6 7 В 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 ng Choose whether you want to analyze multiple tables Add this data to the Data Model СК Point Average 3/41.925 Count: 2807 Min 1 Mac 12300 Sum: 2993540 # - + 100 El e T A4) D ENG 13:11 18-05-2020

H55 Max Min.xlsx Feer Pivottable Toci: Reysollan Sivasankar CMB OES File Home Insert Page Layout Formulas Formulas Data Review View Developer Help Analyze Design Tell me what you want to do Share Row Headers Banded Rows Column Headers Handed Columns Subtotals Grand Report Blank Totals - Layout - Rows- Layout PivosTable Style Options Pictable Styles A3 X f Program . A B D E F H I j K L M N Р 1 Pivot Table F.. X Choose fields to add to report: Search 3 Program 4 DecSc 5 Decsc 6 DecSc 7 DecSc 8 DecSc 9-Decse 10 Decse 11 Deesc 12 - DeeSe 13 DeeSe 14 Desc 15 Math 16 Math 17 Math 18 Math 19 Math 20 - Stat 21 Stat 22 Stat 23 Stat 24 Stat 25 Grand Total 26 27 28 29 2 Sheet1 Level of Work - Sum of Salary Director 192200 Executive 738800 Lecturer 37400 Miscellaneous 14900 Teacher 25500 Director 11600 Executive 24600 Executive 8600 Executive 10300 Teacher 4200 Director 12000 Director 161500 Executive 616500 Lecturer 50100 Miscellaneous 11200 Teacher 18300 Director 207400 Executive 686500 Lecturer 35300 Miscellaneous 9600 Teacher 36800 2913300 Na, Program | | Gender EssentialQualification Working Sector M Level of Work Salary More Tables Drag fields between areas below: Y filters | Columns Values Rows Program Level of.. - Surn of Sa.. Sheet2 Sheet11 Sheets Defer layout Linda.. priate + STE + 100% El e to e T a. A4) D ENG 13:12 18-05-2020

55 Max Min.xlsx Fuen ProtTable Tocis Reysollan Sivasankar CMB QES File Home Insert Page Layout Formulas Data Review View Developer Help Analyze Design Tell me what you want to do Share * Expand Field Ex IH Pivot lable Name PivotTablet Options Pivot Table Active Field: Program Drill Drill FoField Settings Down Up Active Feld → Group Selection Ungroup Group Field Group Collapse Field 2 Refresh Change Data Source - Insert Insert Filter Slicer Timeline Connections Fiter Clear Select Move Pivot lable Actions Fields, Items OLP Telationships & Sets Tools Calculation: Data i? PivotChart Recommended Field +/- Protlables List Buttons Headers Tools Show Pivot Chart Insert a PivotChart tied to the data in this Pivot Table A3 f . Program A B D E F H I j L M N o 1 X Pivot Table F.. Choose fields to add to героrt Search Na, Program | | Gender Essential Qualification Working Sector M Level of Work Salary 3 Program 4 DecSc 5 Decsc 6 Decsc 7 DecSc 8 DecSc 9-Decse 10 Decse 11 Deesc 12 - DeeSe 13 DeeSe 14 Desc 15 Math 16 Math 17 Math 18 Math 19 Math 20 - Stat 21 Stat 22 Stat 23 Stat 24 Stat 25 Grand Total 26 27 28 29 2 Sheet1 Level of Work - Sum of Salary Director 192200 Executive 738800 Lecturer 37400 Miscellaneous 14900 Teacher 25500 Director 11600 Executive 24600 Executive 8600 Executive 10300 Teacher 4200 Director 12000 Director 161500 Executive 616500 Lecturer 50100 Miscellaneous 11200 Teacher 18300 Director 207400 Executive 686500 Lecturer 35300 Miscellaneous 9600 Teacher 36800 2913300 More Tables Drag fields between areas below: Y filters | Columns Values Rows Program Level of.. - Surn of Sa.. Sheet2 Sheet11 Sheets Defer layout unda.. print + STE - + 100% El e to e T a. A4) D CNG 13:13 18-05-2020

H55 Max Min.xlsx - Excel Reysollan Sivasankar CMB OES Share File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Split ✓ Formula Bar ✓ Ruler View Side by Side 10 Ilide IDI Synchronous scrolling Normal Page Break Page Custom Gridlines Headings Zoom 100% Zoom to New range Freeze Switch Preview Layout Views Selection Window All Panes. Unhide Panes. Unhide Neset Window Position Reset Window Position Windows Workbook Views Show Zoom Window Macros Macros 019 X f B C D E F H T K L M N P O R S - 36 35300 9500 Decsc Director 199200 Decc Executive Decsc Lecturer G&GGOO Decse Dec5c Miscellaneous DecSc Teacher Decse Director Decse Executive 73ROO A 1 2 3 Program 4 DecSc 5 Decsc 6 Decsc 7 DecSc 8 DecSc 9-Decse 10 11 Deesc 12 - DeeSe 13 DeeSe 14 Desc 15 Math 16 Math 17 Math 18 Math 19 Math 20 - Stat 21 Stat 22 Stat 23 Stat 24 Stat 25 Grand Total 26 27 28 29 20 Sheet1 Level of Work - Sum of Salary Director 192200 Executive 738800 Lecturer 37400 Miscellaneous 14900 Teacher 25500 Director 11600 Executive 24600 Executive 8600 Executive 10300 Teacher 4200 Director 12000 Director 161500 Executive 616500 Lecturer 50100 Miscellaneous 11200 Teacher 18300 Director 207400 Executive 686500 Lecturer 35300 Miscellaneous 9600 Teacher 36800 2913300 Deesc Executive Deese Executive Deese Toucher 207400 Dese Director 10300 11200 Math Director 37400 14900 35500 11600 24600 50100 G16000 Math Executive Math Lecturer Math Miscellaneous 8000 12000 _4200 10300 Sheet2 Sheet11 Sheets + STE ell + 100% El e to e T a. AC A D ENG 13:16 18-05-2020

H55 Max Min.xlsx Pivot Table Tools Reysollan Sivasankar CMB OES File Home Insert Page Layout Formulas Data Review View Developer Help Analyze Design Tell me what you want to do Share ✓ Ruler ✓ Formula Bar Gridlines M Headings LO Zoom 100% Zoom to Selection Zoom Normal Page Break Page Custom Preview Layout Views Workbook Views Split View Side by Side Ilide IDI Synchronous scrolling New range Freeze Window All Panes - Unhide Panes. Unhide reset Window Position Window Macros Switch Windows Show Matros B4 X f 2085300 с D E F G н I J K L M N 0 P Pivot Table F.. X Choose fields to add to report 84800 35700 Search 122800 No. Program I Gender EssentialQualification Working Sector M Level of Work Salary 554703 A B 1 2 3 Level of Work 1 Sum of Salary 4 Executive 2085300 5 Director 584700 6 Lecturer 122800 7 Teacher 84800 8 Miscellaneous 35700 9 Grand Total 2913300 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Executive Director Lecturer Teacher Mocellaneous More Tables. Drag fields between areas below: TORS300 Y filters | Columns Rows Σ Value Sum of Sa.. Level of 28 29 Sheet1 Sheet2 Sheet11 Sheets + Defer layout Linda.. priate A STE + 100% El e to e T a. A4) D CNG 13:17 18-05-2020

55 Max Min.xlsx - Excel Reysollan Sivasankar CMB OES View Developer Help Tell me what you want to do Share Data Analysis EE File Home Insert Page Layout Formulas Data Review [From Access Show Queries arrom Web From Table From Other Existing New From Text Sources - Connections Query- Recent Sources Get External Data Get Transform Connections E Properties Refresh All - Edit Links Connections 201412 A Sort Clear Reapply Advanced Flash Fill Consolidate - Remove Duplicates a Relationships Data Validation - Gi Manage Data Model F Group Ungroup Subtotal Filter Text to Columns What-if Forecast Analysis - Sheet Forecast Sort & Fiter Data Tools Outline Analysis 022 f с D E F G H 1 j K L M N P Q R S T 100500 Decse Deesc A B 1 2 3 Program Sum of Salary 4 DecSc 1008800 5 Decse 36200 6 Deesc 8600 7 DeeSe 14500 8 Desc 12000 9 Math 857600 10 Stat 975600 11 Grand Total 2913300 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Math Stal 352 8000 357000 14500 12000 Sheet1 Sheet2 Sheet11 Sheets + A STE + 100% El e to e T a. AC A D ENG 13:18 18-05-2020

Mean 7283.25 Standard Error 138.9438 Median 7400 Mode 11000 Standard Deviation 2778.876 Sample Variance 7722150 Kurtosis -1.20564 Skewness -0.01358 Range 12100 Minimum 200 Maximum 12300 Sum 2913300 Count 400 Largest(1) 12300 Smallest(1) 200 Confidence Level(95.0%) 273.1534

Boxplot of Salary O x Boxplot of Salary 12000 10000 8000 Salary 6000 4000 2000 0

Statistics N* Median Q3 N 400 Mean 7283 SE Mean 139 StDev 2779 Sum 2913300 Minimum 200 Q1 4725 Maximum 12300 0 7400 10000 Variable Salary Variable Salary Skewness -0.01