AL Crain's Quartiles and Statistics Assignment will close on Mar 21 at 11:59 P.M. Instructions I would suggest reviewing Chapter 8 before attempting the assignment. This assignment requires working with SUMIF, AVERAGEIF, and COUNTIF. In addition, you will need to have an understanding of statistical functions QUARTILE.EXC. Remove my name and replace it with yours Remember, a date function at the bottom of your spreadsheet (anywhere is fine.) Instructions I would suggest reviewing Chapter 8 before attempting the assignment. This assignment requires working with SUMIF, AVERAGEIF, and COUNTIF. In addition, you will need to have an understanding of statistical functions QUARTILE.EXC. Remove my name and replace it with yours Remember, a date function at the bottom of your spreadsheet (anywhere is fine.) Quartiles 1 2 3 Quartiles Total Sales $ 564,103 1,154,422 2,064,113 YOUR NAME Date Function Summary Statistics Intro Intro-General Total Sales $ 17,876,251 S 11,198,548 Averages $ 1,489,688 5 2,239,710 12 Function is focial Psycholy Discipline Area Introductory General Aging/Death Death and Dying Race/Class/Gender Race/Ethnicity Introductory General Research/Stats Research Methods Research/Stats Social Statistics Race/Class/Gender Gender Issues Social Psychology General Introductory General Criminal Justice Deviance Social Psychology General Research/Stats Social Statistics Aging/Death Death and Dying Social Psychology Symbolic Interactionism Family Family Interaction Social Problems General Research/Stats Research Methods Introductory Social Sciences Race/Class/Gender Gender Issues Race/class/Gender Race/Ethnicity Race/Class/Gender Gender Issues Research/Stats Research Methods Criminal Justice Deviance Introductory Social Sciences Social Problems Violence/Abuse Race/Class/Gender Human Sexuality Social Psychology General es: ales: Total Book Book Title Jition "holesale Retail Sales Contemporary Sociology 3,740,000 130,000 5 3,870,000 Interpretations in Grief and Loss $ 3,564,000 187,187 5 3,751,187 Bridging the Gap in Racial Groups co $ 3,218,75 201,142 $3,419,89 Sociology: An Introduction 8 $ 3,055 294,500 5 3,346, 10 $ 3,0 755 226,688 5 3,243 63 SUNIE Research 8 $6,875 S 202,935 5 3, 1810 5 $ 73,750 $ 169,000 $ 1.750 1 988,045 5 127,9505 15,995 Required in 8 2,724,777 5 79,335 804,112 9 2,512,500 $ 280,849 2,793,349 An Introduction to Symbolic ctionism $ 2,531,250 $ 180,04 2,711,298 Behavioral and Social Sci tatistics $ 2,569,675 109,2,679,475 Death in Society $ 2,625,000 5 1 S 2,641851 Symbolic Interact An Introduction $ 2,368,750 $ 5 2,638,352 ans $ 2 IS 2,388,642 AVERAGEIF COUNTIF $ 2 RANKAVG 5 2,352,200 e Resear $ 2 $ 2,351,660 Function is Function is Function is Science S2 IS 2,316,896 Required in and Wome Required in $ 2 Required in $2,314,992 Cell F4 & G4 and Ethn Cell F5 & G5 $ 2 Column $ 2,164,250 $ 2 Is 2,083,950 Qualitative Research for Social Sciences $ 1,927,500 5 130,000 5 2.057.500 Deviant Behavior 1 $ 1,859,000 $ 169,000 5 2,028,000 Introduction to Social Sciences 2 $2,017,620 5,265 $ 2,022 889 Increasing Violence in Our Schools 2 $ 1,998,620 $ 18,590 52,017,210 Human Sexuality 5 $ 1,804,550 $ 133,200 5 1,937,750 Social Psychology 3 $ 1,822,065 $ 89,050 $ 1,911,115 Rank 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 Gender Quarties YOUR NAME Date Function Rank Diciple Introductory Aging Death Race/Class/Gender Introductory Research Stats Research Stats Race/Class/Gender Social Pwychology Introductory Criminal Justice Social Psychology Research Stats Aging/Death Social Psychology Family Social Problems Restarchy Stats Introductory Race/Clan/Gender Race/Cus/Gerder Races/Gender Research Stats Criminallustice Introductory Soca Probleme Race/Class/Gender Social Psychology Miscellaneous ruce/Class/Gender Apr/Drath Family Socul Pytholo Social Problem Research Fay Research Stats Race/ss/Gender Family Social Protes Race/Classe RaceChender A/Drah Social Social Problem Real Clusti Ana General Death and Dying Race/Ethnicity General Research Methods Social Statistics Gender Issues General General Deviance General Social Statistics Death and Dying Symbolik Imeractions Family Interaction General Research Methods Social Sciences Gender Issues Race/Ethnkity Gender Issues Research methods Deviance Social Sciences Violence/Abuse Human Sexuality General Social Theory Gender Death and Dying Marrue and Same Symbol interactions General Social Statistics Family interaction Analysis Sexuality Marriage and Family Book Title Contemporary Sociology Interpretations in Greland Loss Bridging the Gap in Rocal Group Sociology: An Introduction Researching in Social Sciences Introductory Statistics in Social Research Gender Rokes in Society Modern Perspectives on Social Psychology Sociology 101 Deviant behavior An Introduction to Symbolic interaction Dehavioral and Social Sciences Statistics Death in Society Symbolic Interactionism: An Introduction Trends in Family Interactions Current Social Problems Quantitative and Qualiative Research Methods Modern Approach to Social Science Social Constructs for Men and Women America: Diversity in Race and Ethnicity Sociological perspectives on Gerder Qualitative Research for Social Sci Deviant Behavior Introduction to Social Sciences Increasing Violence in Our Schools Human Selity Soca Psychology Modern Sociological Theories Introduction to Gender Humans Aging and Death Marriages and Family Matters Synonteractioncm:rel Editor Soco Problems Statistical Procedures for Solo Family interactions. A Develpietal Approach SPSS Analytin Dita Understanding Human Diversity and change in Today Manage Address Sobre Goede hoy Womens O AMOR Copy Deck the role SKA YA Summary Statistics hitro General Toual Sales Average Sales w of Boole Sales San Total Book Edtion Wholesale Sales 2,740,0DOS 110 DOO 2 3 1,5HP 187,187 10 $ 2,218,7505 201,142 $ 3,051,585 5 294,500 10 3,016,575 S 226,658 $ 2,945,875 $ 202,935 5 $ 2,973.750 $ 169,000 1 $ 2.988,045 S 127,950 8 $ 2,724,7775 79.235 9 $ 2,512,500 5 280,849 $ 2,531,250 $ 180,048 6 $ 2,569,675 $ 109.800 $ 2.625,000 16.851 7 $ 2,168,750 $ 269,502 10 $ 2,187,500 201.142 10 S 2,334,500 $ 17.700 9 $ 2,111,100 $ 40,560 10 2,298,750 $ 23,146 $ 2.247,600 $ 67,292 10 $ 2,127,500 16.750 5 $ 2,070,000 12,950 6 1.927,500 110,000 1 1.859.000 169.000 2 S 2.017,620 5,265 2 1.298,620 S 18,590 1.804,550 $ 223.200 1.822,065 $ 89,050 1410,000 S 213.000 1.603,125 211 200 4 1,218,755 12,741 3.404,250 S 168542 1.497,90 17.712 1.433.100 3 12.000 1,413,3253 12888 280,000 2020 105 13,3 1163 5 10,000 1200 205 2203 24100 31,104,10 1050 WM 500 1200 1125 800 NO 12.400 150 1403 1.100 723403 3.90 2. Gender Gender Soov oling Volke/A Set usque 2 5 1 2 2 Social Psychology Social Problems AnalStats Criminal Justice Introductory AgnDeath Social Problems Apr/Death Macellaneous Research Seats Research Seats Family Social Psychology Researly stats Race/class/Gender Introductory Research Stats Research Stats Racecos/Gender Aging/Death Criminal Justice Criminal Justice Family Introductory Research Stats Introductory Race/Cus/Gender Research Ang/Death Social Psychology Social Problems Socul Problem Agneath Fami Race/Clas/Gender Criminalistice Miscellaneous Introductory So Problem Macaco SOL Problem troductor Intrody General Violenct/Abuse Social Statistics Juve Dequency Conflict Approach Sociology of Aging General Sociology of Agine Social Change Social Statistics Data Analysis Family Interaction General Data Analysis Human Sexy General Research Methods Data Analysis Human Sexuality Sociology of Aging Iwerde Delinquency Juvenile Delinquency Marriage and Family Social Sciences Research Methods General Race/Ethnicity Social State Sociology of Aging Symbol Interactions Violerke/Abuse Akohol/Drugs Sociology of Aging Mamage and family Human See Devanke Social Change Macroscopy Approach Akohores Social Change Contact Approach Macroecology Approach Cont Approach Social Theory Aeadings in Social Psychology Domen Valence Trends and Prevention Sociology Seattle Juvenil Delinquency: A Sociological Approach Conica in society The Aging Proces Social Ineque les Around the Globe Sociology of Aging Exploring Social Changes Statistics for Socials Using SPSS for Rearch in Sociology Family Dyrams: A Modern Perspective Social Pychology: An Interaction Approach Data Arali using SPSS Stuality Around the Globe Contemporary Sociology Brief Edition Fundamentals of Research Analysing Sociology Research with SPSS Psychology and Human Sexuality Quality of Life as We Age Juvenile Delinquency An Introduction to Juvenile Delinquency A Global Perspective on Marriage Modern Approach to Social Science Brie Understanding Research Methods Welcome to Sociology Changes and challenges in the US Fundamentals of Social Statistis Concerns and issues in Aging Looking at Self and Society Chad Abuse in Today's World Current Trends in Alcohol and Drug Abuse Human Ages Relations in Marriages Amarca: Diversity in Seat A Collection of Readings in Den Bei Solutions to Our Sexcal Problems Dynamics of Mactofociology understanding Akoholandon Bhavior Global Concerns of Society A Conflict Approach Star Pro MOCIO Conflicts in society id on Theories of society 1,162,550 $ 1,135,7405 1,122,400 5 $ 1,012.150 S 1,062,475 5 1,041,2005 1,019,610 5 954,8905 932,625 $ 168,250 $ 815,625 5 313,875 S 763,220 675,000 $ 680,000 $ 659,0655 $ 640,220$ 644,250 $ $ 614,550 $ $ 604,800 $ s 600,000 5 $ 496,145 $ 5 562,7255 $ 550,500 5 $ $26.125.5 5 502,215 5 s 495,000 $ 5 457.500 5 $ 457.8955 452,2855 427.500 5 405,000 $ 427.500 5 405,000 $ 418,125$ 340,5606 325,9205 255.000 $ 284,850 247,500 262.500 212.500 5 251.250 53.750 $ 7.154 2.300 LPSO 87.750 22,700 5.500 18,011 8.410 11,916 12,200 9,800 4772 15.252 11,700 4,600 6,696 9,212 4,704 12,765 7,176 5,512 70,152 2,842 9,212 21,450 10,275 13,338 8190 2,774 1.721 7,003 36,504 1.488 16.614 2.136 5.487 1,170 46,298 6,604 18,072 2,352 11211 5,976 1.110 2 1 5 Student Name AL Crain's Quartiles and Statistics Assignment will close on Mar 21 at 11:59 P.M. Instructions I would suggest reviewing Chapter 8 before attempting the assignment. This assignment requires working with SUMIF, AVERAGEIF, and COUNTIF. In addition, you will need to have an understanding of statistical functions QUARTILE.EXC. Remove my name and replace it with yours Remember, a date function at the bottom of your spreadsheet (anywhere is fine.) Instructions I would suggest reviewing Chapter 8 before attempting the assignment. This assignment requires working with SUMIF, AVERAGEIF, and COUNTIF. In addition, you will need to have an understanding of statistical functions QUARTILE.EXC. Remove my name and replace it with yours Remember, a date function at the bottom of your spreadsheet (anywhere is fine.) Quartiles 1 2 3 Quartiles Total Sales $ 564,103 1,154,422 2,064,113 YOUR NAME Date Function Summary Statistics Intro Intro-General Total Sales $ 17,876,251 S 11,198,548 Averages $ 1,489,688 5 2,239,710 12 Function is focial Psycholy Discipline Area Introductory General Aging/Death Death and Dying Race/Class/Gender Race/Ethnicity Introductory General Research/Stats Research Methods Research/Stats Social Statistics Race/Class/Gender Gender Issues Social Psychology General Introductory General Criminal Justice Deviance Social Psychology General Research/Stats Social Statistics Aging/Death Death and Dying Social Psychology Symbolic Interactionism Family Family Interaction Social Problems General Research/Stats Research Methods Introductory Social Sciences Race/Class/Gender Gender Issues Race/class/Gender Race/Ethnicity Race/Class/Gender Gender Issues Research/Stats Research Methods Criminal Justice Deviance Introductory Social Sciences Social Problems Violence/Abuse Race/Class/Gender Human Sexuality Social Psychology General es: ales: Total Book Book Title Jition "holesale Retail Sales Contemporary Sociology 3,740,000 130,000 5 3,870,000 Interpretations in Grief and Loss $ 3,564,000 187,187 5 3,751,187 Bridging the Gap in Racial Groups co $ 3,218,75 201,142 $3,419,89 Sociology: An Introduction 8 $ 3,055 294,500 5 3,346, 10 $ 3,0 755 226,688 5 3,243 63 SUNIE Research 8 $6,875 S 202,935 5 3, 1810 5 $ 73,750 $ 169,000 $ 1.750 1 988,045 5 127,9505 15,995 Required in 8 2,724,777 5 79,335 804,112 9 2,512,500 $ 280,849 2,793,349 An Introduction to Symbolic ctionism $ 2,531,250 $ 180,04 2,711,298 Behavioral and Social Sci tatistics $ 2,569,675 109,2,679,475 Death in Society $ 2,625,000 5 1 S 2,641851 Symbolic Interact An Introduction $ 2,368,750 $ 5 2,638,352 ans $ 2 IS 2,388,642 AVERAGEIF COUNTIF $ 2 RANKAVG 5 2,352,200 e Resear $ 2 $ 2,351,660 Function is Function is Function is Science S2 IS 2,316,896 Required in and Wome Required in $ 2 Required in $2,314,992 Cell F4 & G4 and Ethn Cell F5 & G5 $ 2 Column $ 2,164,250 $ 2 Is 2,083,950 Qualitative Research for Social Sciences $ 1,927,500 5 130,000 5 2.057.500 Deviant Behavior 1 $ 1,859,000 $ 169,000 5 2,028,000 Introduction to Social Sciences 2 $2,017,620 5,265 $ 2,022 889 Increasing Violence in Our Schools 2 $ 1,998,620 $ 18,590 52,017,210 Human Sexuality 5 $ 1,804,550 $ 133,200 5 1,937,750 Social Psychology 3 $ 1,822,065 $ 89,050 $ 1,911,115 Rank 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 Gender Quarties YOUR NAME Date Function Rank Diciple Introductory Aging Death Race/Class/Gender Introductory Research Stats Research Stats Race/Class/Gender Social Pwychology Introductory Criminal Justice Social Psychology Research Stats Aging/Death Social Psychology Family Social Problems Restarchy Stats Introductory Race/Clan/Gender Race/Cus/Gerder Races/Gender Research Stats Criminallustice Introductory Soca Probleme Race/Class/Gender Social Psychology Miscellaneous ruce/Class/Gender Apr/Drath Family Socul Pytholo Social Problem Research Fay Research Stats Race/ss/Gender Family Social Protes Race/Classe RaceChender A/Drah Social Social Problem Real Clusti Ana General Death and Dying Race/Ethnicity General Research Methods Social Statistics Gender Issues General General Deviance General Social Statistics Death and Dying Symbolik Imeractions Family Interaction General Research Methods Social Sciences Gender Issues Race/Ethnkity Gender Issues Research methods Deviance Social Sciences Violence/Abuse Human Sexuality General Social Theory Gender Death and Dying Marrue and Same Symbol interactions General Social Statistics Family interaction Analysis Sexuality Marriage and Family Book Title Contemporary Sociology Interpretations in Greland Loss Bridging the Gap in Rocal Group Sociology: An Introduction Researching in Social Sciences Introductory Statistics in Social Research Gender Rokes in Society Modern Perspectives on Social Psychology Sociology 101 Deviant behavior An Introduction to Symbolic interaction Dehavioral and Social Sciences Statistics Death in Society Symbolic Interactionism: An Introduction Trends in Family Interactions Current Social Problems Quantitative and Qualiative Research Methods Modern Approach to Social Science Social Constructs for Men and Women America: Diversity in Race and Ethnicity Sociological perspectives on Gerder Qualitative Research for Social Sci Deviant Behavior Introduction to Social Sciences Increasing Violence in Our Schools Human Selity Soca Psychology Modern Sociological Theories Introduction to Gender Humans Aging and Death Marriages and Family Matters Synonteractioncm:rel Editor Soco Problems Statistical Procedures for Solo Family interactions. A Develpietal Approach SPSS Analytin Dita Understanding Human Diversity and change in Today Manage Address Sobre Goede hoy Womens O AMOR Copy Deck the role SKA YA Summary Statistics hitro General Toual Sales Average Sales w of Boole Sales San Total Book Edtion Wholesale Sales 2,740,0DOS 110 DOO 2 3 1,5HP 187,187 10 $ 2,218,7505 201,142 $ 3,051,585 5 294,500 10 3,016,575 S 226,658 $ 2,945,875 $ 202,935 5 $ 2,973.750 $ 169,000 1 $ 2.988,045 S 127,950 8 $ 2,724,7775 79.235 9 $ 2,512,500 5 280,849 $ 2,531,250 $ 180,048 6 $ 2,569,675 $ 109.800 $ 2.625,000 16.851 7 $ 2,168,750 $ 269,502 10 $ 2,187,500 201.142 10 S 2,334,500 $ 17.700 9 $ 2,111,100 $ 40,560 10 2,298,750 $ 23,146 $ 2.247,600 $ 67,292 10 $ 2,127,500 16.750 5 $ 2,070,000 12,950 6 1.927,500 110,000 1 1.859.000 169.000 2 S 2.017,620 5,265 2 1.298,620 S 18,590 1.804,550 $ 223.200 1.822,065 $ 89,050 1410,000 S 213.000 1.603,125 211 200 4 1,218,755 12,741 3.404,250 S 168542 1.497,90 17.712 1.433.100 3 12.000 1,413,3253 12888 280,000 2020 105 13,3 1163 5 10,000 1200 205 2203 24100 31,104,10 1050 WM 500 1200 1125 800 NO 12.400 150 1403 1.100 723403 3.90 2. Gender Gender Soov oling Volke/A Set usque 2 5 1 2 2 Social Psychology Social Problems AnalStats Criminal Justice Introductory AgnDeath Social Problems Apr/Death Macellaneous Research Seats Research Seats Family Social Psychology Researly stats Race/class/Gender Introductory Research Stats Research Stats Racecos/Gender Aging/Death Criminal Justice Criminal Justice Family Introductory Research Stats Introductory Race/Cus/Gender Research Ang/Death Social Psychology Social Problems Socul Problem Agneath Fami Race/Clas/Gender Criminalistice Miscellaneous Introductory So Problem Macaco SOL Problem troductor Intrody General Violenct/Abuse Social Statistics Juve Dequency Conflict Approach Sociology of Aging General Sociology of Agine Social Change Social Statistics Data Analysis Family Interaction General Data Analysis Human Sexy General Research Methods Data Analysis Human Sexuality Sociology of Aging Iwerde Delinquency Juvenile Delinquency Marriage and Family Social Sciences Research Methods General Race/Ethnicity Social State Sociology of Aging Symbol Interactions Violerke/Abuse Akohol/Drugs Sociology of Aging Mamage and family Human See Devanke Social Change Macroscopy Approach Akohores Social Change Contact Approach Macroecology Approach Cont Approach Social Theory Aeadings in Social Psychology Domen Valence Trends and Prevention Sociology Seattle Juvenil Delinquency: A Sociological Approach Conica in society The Aging Proces Social Ineque les Around the Globe Sociology of Aging Exploring Social Changes Statistics for Socials Using SPSS for Rearch in Sociology Family Dyrams: A Modern Perspective Social Pychology: An Interaction Approach Data Arali using SPSS Stuality Around the Globe Contemporary Sociology Brief Edition Fundamentals of Research Analysing Sociology Research with SPSS Psychology and Human Sexuality Quality of Life as We Age Juvenile Delinquency An Introduction to Juvenile Delinquency A Global Perspective on Marriage Modern Approach to Social Science Brie Understanding Research Methods Welcome to Sociology Changes and challenges in the US Fundamentals of Social Statistis Concerns and issues in Aging Looking at Self and Society Chad Abuse in Today's World Current Trends in Alcohol and Drug Abuse Human Ages Relations in Marriages Amarca: Diversity in Seat A Collection of Readings in Den Bei Solutions to Our Sexcal Problems Dynamics of Mactofociology understanding Akoholandon Bhavior Global Concerns of Society A Conflict Approach Star Pro MOCIO Conflicts in society id on Theories of society 1,162,550 $ 1,135,7405 1,122,400 5 $ 1,012.150 S 1,062,475 5 1,041,2005 1,019,610 5 954,8905 932,625 $ 168,250 $ 815,625 5 313,875 S 763,220 675,000 $ 680,000 $ 659,0655 $ 640,220$ 644,250 $ $ 614,550 $ $ 604,800 $ s 600,000 5 $ 496,145 $ 5 562,7255 $ 550,500 5 $ $26.125.5 5 502,215 5 s 495,000 $ 5 457.500 5 $ 457.8955 452,2855 427.500 5 405,000 $ 427.500 5 405,000 $ 418,125$ 340,5606 325,9205 255.000 $ 284,850 247,500 262.500 212.500 5 251.250 53.750 $ 7.154 2.300 LPSO 87.750 22,700 5.500 18,011 8.410 11,916 12,200 9,800 4772 15.252 11,700 4,600 6,696 9,212 4,704 12,765 7,176 5,512 70,152 2,842 9,212 21,450 10,275 13,338 8190 2,774 1.721 7,003 36,504 1.488 16.614 2.136 5.487 1,170 46,298 6,604 18,072 2,352 11211 5,976 1.110 2 1 5 Student Name