PLEASE ASSIST WITH FORMULAS FOR EMPTY CELLS

A B C D E G H Quartiles Summary Statistics Quartiles Total Sales MELISSA LOPEZ Intro Intro-General 2/26/2023 Total Sales Average Sales # of Books Sales: Sales: Total Book Discipline Area Book Title Edition Wholesale Retai Sales Rank Introductory General Contemporary Sociology 1 3,740,000 5 130,000 Aging/Death Death and Dying Interpretations in Grief and Loss 7 3,564,000 187,187 10 Race/Class/Gende Race/Ethnicity Bridging the Gap in Racial Groups 10 3,218,750 201,142 11 Introductory General Sociology: An Introduction 3,051,685 294,500 12 Research/Stats Research Methods Researching in Social Sciences 10 3,016,575 226,688 13 Research/Stats Social Statistics Introductory Statistics in Social Research 8 2,946,875 $ 202,935 14 Race/Class/Gende Gender Issues Gender Roles in Society 5 2,973,750 169,000 15 Social Psychology General Modern Perspectives on Social Psychology 1 $ 2,988,045 127,950 16 Introductory General Sociology 101 8 2,724,777 79,335 17 Criminal Justice Deviance Deviant Behavior 9 2,512,500 280,849 18 Social Psychology General An Introduction to Symbolic Interactionism 5 2,531,250 180,048 19 Research/Stats Social Statistics Behavioral and Social Sciences Statistics 6 2,569,675 109,800 20 Aging/Death Death and Dying Death in Society 2 $ 2,625,000 16,851 21 Social Psychology Symbolic Interactionism Symbolic Interactionism: An Introduction 7 $ 2,368,750 269,602 Family Family Interaction Trends in Family Interactions 10 2,187,500 201,142 23 Social Problems General Current Social Problems 10 2,334,500 17,700 24 Research/Stats Research Methods Quantitative and Qualitative Research Metho 9 2,311,100 40,560 in to 5 Introductory Social Sciences Modern Approach to Social Science 10 2,293,750 23,146 Race/Class/Gende Gender Issues Social Constructs for Men and Women 2,247,600 67,392 27 Race/Class/Gende Race/Ethnicity America: Diversity in Race and Ethnicity 10 2,127,500 36,750 28 Race/Class/Gende Gender Issues Sociological Perspectives on Gender 5 $ 2,070,000 13,950 29 Research/Stats Research Methods Qualitative Research for Social Sciences 6 $ 1,927,500 130,000 30 Criminal Justice Deviance Deviant Behavior 1 1,859,000 169,000 31 Introductory Social Sciences Introduction to Social Sciences 2 2,017,620 5,265 $2 Social Problems Violence/Abuse Increasing Violence in Our Schools 2 1,998,620 18,590 $3 Race/Class/Gende Human Sexuality Human Sexuality 5 $ 1,804,550 133,200 34 Social Psychology General Social Psychology 3 1,822,065 89,050 35 Miscellaneous Social Theory Modern Sociological Theories $ 1,610,000 213,000 36 Race/Class/Gende Gender Issues Introduction to Gender Issues $ 1,603,125 211,200 37 Aging/Death Death and Dying Humans: Aging and Death 1,758,750 12,741 Family Marriage and Family Marriages and Family Matters 1,404,250 168,542 Social Psychology Symbolic Interactionism Symbolic Interactionism: Brief Edition 1,497,960 17,732 183 300 2.090Quartiles Summary Statistics Quartiles Total Sales YOUR NAME Intro Intro-General 564,103 Date Function Total Sales $ 17,876,251 $ 11,198,548 1,154,422 Average SHas $ 1,489,688 $ 2,239,710 W N 2,064,113 # of Books 12 S es: Files: Total Book Discipline Area Book Title .dition Wholesale Retail Sales Rank Introductory General Contemporary Sociology 3,740,000 130,000 $ 3,870,000 Aging/Death Death and Dying Interpretations in Grief and Loss 3,564,000 187,187 3,751,187 WN Race/Class/Gender Race/Ethnicity Bridging the Gap in Racial Groups S 3,218,7 S 201,142 5 3,419,897 Introductory General Sociology: An Introduction 8 S 3,051 S 294,500 3,346,1/ Research/Stats Research Methods 10 3.0 675 226,688 $ 3,243 63 Research/Stats Social Statistics SUNIF Research 8 6,875 $ 202,935 $ 3,1/ 810 Race/Class/Gender Gender Issues 5 73,750 169,000 2,750 Social Psychology General Function is Social Psycholo ,988,045 127,950 15,995 00 Introductory General Required in 2,724,777 S 79,335 ,804,112 Criminal Justice Deviance 2,512,500 280,849 2,793,349 10 Social Psychology General An Introduction to Symbolic ctionism S 2,531,250 S 180,049 2,711,298 11 Research/Stats Social Statistics Behavioral and Social Scis statistics 2,569,675 109,8 2,679,475 12 Aging/Death Death and Dying Death in Society 2,625,000 $ 2,641,851 13 in Social Psychology Symbolic Interactionism Symbolic Interacti An Introduction 2,368,750 2,638,352 14 Family Family Interaction Ins 2,388,642 15 Social Problems General AVERAGEIF COUNTIF RANKAVG 2,352,200 16 Research/Stats Research Methods ve Resear Function is Function is Function is 2,351,660 17 Introductory Social Sciences I Science 2,316,896 18 Race/Class/Gender Gender Issues Required in and Wom Required in Required in 2,314,992 19 Race/Class/Gender Race/Ethnicity Cell F4 & G4 and Ethni Cell F5 & G5 Column 2,164,250 20 Race/Class/Gender Gender Issues n Gender S N 2,083,950 21 Research/Stats Research Methods Qualitative Research for Social Sciences 6 S 1,927,500 $ 130,000 $ 2,057,500 22 Criminal Justice Deviance Deviant Behavior S 1,859,000 S 169,000 $ 2,028,000 23 Introductory Social Sciences Introduction to Social Sciences S 2,017,620 $ 5,265 2,022,885 24 Violence/Abuse Increasing Violence in Our Schools WUNNA Social Problems 1,998,620 $ 18,590 $ 2,017,210 25 Race/Class/Gender Human Sexuality Human Sexuality 1,804,550 133,200 $ 1,937,750 26 Social Psychology General Social Psychology S 1,822,065 S 89,050 $ 1,911,115 27A few functions you will need to insert in completing this assignment: addition SUMIF = is a range of cells that you want evaluated by criteria. . The criteria can be described in the form of a number, expression or text that defines which cells will be added. For example, criteria can be expressed as 32,"32", ">32", or even "apples". AVERAGEIF = is the range of cells that you want to average Cells in range must contain numbers, name array, or cell reference that contain numbers Cells in range that contain TRUE or FALSE are ignored If range contains blank cells or cells containing text values - AVERAGEIF will return the #Div/O! Error-value! . If the cell in criteria is empty..it will return a zero value. COUNTIF = is known for range.criteria Range is the range of cells from which you want to count cells . Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. . Examples: =COUNTIF (A2:A5,"apples") Number of cells with apples in the first column above (2) . =COUNTIF (A2:A5, A4) . Number of cells with peaches in the first column above (1) . =COUNTIF(A2:A5,A3)+COUNTIF Number of cells with (A2:A5,A2) oranges or apples in the first column above (3) O