2- Suppose you have the fallowing code segment convert it to suitable excel formula , Note: Suppose the Range A2:A6 content the Gender value (Male or Female), and the range B2:B6 content the any numerical value S=0 ;C=0 For i=2 to 6 If A[i] ="male" and B[i] >=20 then s=s+B[i] c=c+1 end if Output s/ c

2- Suppose you have the fallowing code segment convert it to suitable excel formula , Note: Suppose the Range A2:A6 content the Gender value (Male or Female), and the range B2:B6 content the any numerical value S=0 ;C=0 For i=2 to 6 If A[i] ="male" and B[i] >=20 then s=s+B[i] c=c+1 end if Output s/ c

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Computer science Short answer Explain puplic and secret key
How many of you are familiar with Ada Lovelace's contributions to mathematics?
Are there any noteworthy discrepancies between the results of search engines and library databases while doing research on certain topics?
How long has the field of computer science existed?
Please share your Automata Theory applications.
When was the phantom of the opera first performed
What is the full name of Mark Dean's parents?
Mark Dean's address is unknown.