management question and need guidance to help me learn. 1- Action Required: Watch the video at the following link Test your Knowledge (Question): Define new public management as

management question and need guidance to help me learn.

1- Action Required:
Watch the video at the following link
Test your Knowledge (Question):
Define new public management as an approach to performance management
Define new public service as an approach to performance management

2-Action Required:
Chapters 9 & 10 in BUSINESS COMMUNICATION: Developing Leaders for a Networked World, Peter Cardon, 4th Edition McGraw-Hill Education
Watch the short videos at the following link:
7 Workplace Etiquette Tips to Build Stronger Relationships – YouTube
Test your Knowledge (Question):
In chapter 9, you learn about the different types of routine business messages (task-oriented and relationship-oriented). Pick one and write a sample routine message following the element of the selected type.
Find attachment- i will send to you later
3- Action Required:
Watch the short video in the following link and answer the questions that follows:
Top 5 Ethics and Compliance Trends for 2015
7.3 Test your Knowledge (Question):
Think about all of the communication opportunities provided by social media. How could an organization use social media like Facebook, Twitter and the like, to promote ethical behavior and communicate the organizations values? What are the advantages and dangers of those media?
4- Action Required:
Read the following chapter of your Textbook.
Chapter 5: Data Exploration and Visualization
7.3 Test your Knowledge (Question):
Explain various types of Categorical and Numerical Data with examples.
Discuss the Data Exploration process.
Find attachment
Requirements: as answer need
MANAGEMENTSCIENCEThe Art of Modeling with SpreadsheetsSTEPHEN G. POWELLKENNETH R. BAKERCompatible with Analytic Solver PlatformFOURTH EDITIONCHAPTER 5 POWERPOINTData Exploration and visualization
INTRODUCTION?Business analysts must know how to use data to derive business insights and improve decisions. ?Analysts may use data to describe situations (e.g., profit over the last year), predict situations (e.g., profit over the next year), or prescribe actions the organization must take to achieve its goals. ?Several basic skills are required to understand a data set, explore individual variables (or groups of them) for insights, and to prepare data for more complex analysis.?Remain skeptical of data: datasets are only as good as their collection methods (e.g., may have been collected with biases), and may or may not be relevant to the problem at hand. Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.140?ﯾﺟبأنﯾﻌرفﻣﺣﻠﻠواﻷﻋﻣﺎلﻛﯾﻔﯾﺔاﺳﺗﺧداماﻟﺑﯾﺎﻧﺎتﻻﺳﺗﺧﻼصرؤىاﻷﻋﻣﺎلوﺗﺣﺳﯾناﻟﻘرارات.?ﻗدﯾﺳﺗﺧدماﻟﻣﺣﻠﻠوناﻟﺑﯾﺎﻧﺎتﻟوﺻفاﻟﻣواﻗف)ﻋﻠﻰﺳﺑﯾلاﻟﻣﺛﺎل،اﻟرﺑﺢﺧﻼلاﻟﻌﺎماﻟﻣﺎﺿﻲ(،أوﺗوﻗﻊاﻟﻣواﻗف)ﻣﺛلاﻟرﺑﺢﺧﻼلاﻟﻌﺎماﻟﻣﻘﺑل(،أووﺻفاﻹﺟراءاتاﻟﺗﻲﯾﺟبﻋﻠﻰاﻟﻣﻧظﻣﺔاﺗﺧﺎذھﺎﻟﺗﺣﻘﯾقأھداﻓﮭﺎ.?ھﻧﺎكﺣﺎﺟﺔإﻟﻰاﻟﻌدﯾدﻣناﻟﻣﮭﺎراتاﻷﺳﺎﺳﯾﺔﻟﻔﮭمﻣﺟﻣوﻋﺔﺑﯾﺎﻧﺎت،واﺳﺗﻛﺷﺎفاﻟﻣﺗﻐﯾراتاﻟﻔردﯾﺔ(أوﻣﺟﻣوﻋﺎتﻣﻧﮭﺎ(ﻟﻠﺣﺻولﻋﻠﻰرؤى،وإﻋداداﻟﺑﯾﺎﻧﺎتﻟﺗﺣﻠﯾلأﻛﺛرﺗﻌﻘﯾدًا.?اﻟﺑﻘﺎءﻣﺗﺷﻛﻛﺎﻓﻲاﻟﺑﯾﺎﻧﺎت: ﻣﺟﻣوﻋﺎتاﻟﺑﯾﺎﻧﺎتﺟﯾدةﻓﻘطﻣﺛلطرقﺟﻣﻌﮭﺎ(ﻋﻠﻰﺳﺑﯾلاﻟﻣﺛﺎل،رﺑﻣﺎﺗمﺟﻣﻌﮭﺎﻣﻊاﻟﺗﺣﯾزات( ،وﻗدﺗﻛونأوﻻﺗﻛونذاتﺻﻠﺔﺑﺎﻟﻣﺷﻛﻠﺔاﻟﻣطروﺣﺔ.
DATABASE STRUCTURE?Spreadsheet databases are two-dimensional files (versus more complex relational databases).?Consist of:?Rows = records (sometimes, cases? or instances?)?Columns = or fields (sometimes variables,? descriptors,? predictors??Most databases contain a data dictionary that documents fields in detail.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.141?ﻗواﻋدﺑﯾﺎﻧﺎتﺟداولاﻟﺑﯾﺎﻧﺎتھﻲﻣﻠﻔﺎتﺛﻧﺎﺋﯾﺔاﻷﺑﻌﺎد)ﻣﻘﺎﺑلﻗواﻋدﺑﯾﺎﻧﺎتﻋﻼﺋﻘﯾﺔأﻛﺛرﺗﻌﻘﯾدًا(.?ﯾﺗﺄﻟفﻣن:??اﻟﺻﻔوف= اﻟﺳﺟﻼت)أﺣﯾﺎﻧًﺎ،”ﺣﺎﻻت” أو”أﻣﺛﻠﺔ”(??اﻷﻋﻣدة= أواﻟﺣﻘول)أﺣﯾﺎﻧًﺎ”اﻟﻣﺗﻐﯾرات” و”اﻟواﺻﻔﺎت” و”اﻟﻣﺗﻧﺑﺋون”?ﺗﺣﺗويﻣﻌظمﻗواﻋداﻟﺑﯾﺎﻧﺎتﻋﻠﻰﻗﺎﻣوسﺑﯾﺎﻧﺎتﯾوﺛقاﻟﺣﻘولﺑﺎﻟﺗﻔﺻﯾل.
DATABASE STRUCTURE, EXAMPLE?The data dictionary for this sample:Field NameDescriptionIDRecord numberITEMItem numberUPCUniform Product CodeDESCRIPTIONDescriptionSIZEItems per containerSTOREStore numberWEEKWeek numberSALESSales volume in casesChapter 5Copyright ? 2013 John Wiley & Sons, Inc.142
DATABASE STRUCTURE, EXAMPLE?We might use this database to answer the questions:?What were the market shares of the various brands??What were the weekly sales volumes at the various stores?Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.143?ﻗدﻧﺳﺗﺧدمﻗﺎﻋدةاﻟﺑﯾﺎﻧﺎتھذهﻟﻺﺟﺎﺑﺔﻋﻠﻰاﻷﺳﺋﻠﺔ:?ﻣﺎھﻲﺣﺻصاﻟﺳوقﻟﻣﺧﺗﻠفاﻟﻌﻼﻣﺎتاﻟﺗﺟﺎرﯾﺔ؟?ﻣﺎھﻲأﺣﺟﺎماﻟﻣﺑﯾﻌﺎتاﻷﺳﺑوﻋﯾﺔﻓﻲاﻟﻣﺗﺎﺟراﻟﻣﺧﺗﻠﻔﺔ؟
TYPES OF DATA?An infinite variety of data, but just a few common types: ?Categorical data, which includes nominal and ordinal data?Numerical data, which includes interval and ratio dataChapter 5Copyright ? 2013 John Wiley & Sons, Inc.144?ﻣﺟﻣوﻋﺔﻏﯾرﻣﺣدودةﻣناﻟﺑﯾﺎﻧﺎت،وﻟﻛنﻓﻘطﺑﻌضاﻷﻧواعاﻟﺷﺎﺋﻌﺔ:??اﻟﺑﯾﺎﻧﺎتاﻟﻔﺋوﯾﺔاﻟﺗﻲﺗﺗﺿﻣنﺑﯾﺎﻧﺎتاﺳﻣﯾﺔوﺗرﺗﯾﺑﯾﺔ??اﻟﺑﯾﺎﻧﺎتاﻟﻌددﯾﺔ،واﻟﺗﻲﺗﺗﺿﻣنﺑﯾﺎﻧﺎتاﻟﻔﺎﺻلاﻟزﻣﻧﻲواﻟﻧﺳﺑﺔ
TYPES OF DATA: CATEGORICAL VARIABLES?Nominal data, which simply names the category of record. ?Example: A GENDER field, with only two variables (male and female)?Example:The DESCRIPTION field in previous slides, with numerous variables (e.g., ADVIL, TYLENOL X/STRGTH LIQ).?Ordinal data, also identifies category of record but with a natural order to the values. ?Example:High, Medium and Low?Example:Numerical rankings, where 5 = most preferred, 1 = least preferred Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.145?اﻟﺑﯾﺎﻧﺎتاﻻﺳﻣﯾﺔ،اﻟﺗﻲﺗﺳﻣﻲﺑﺑﺳﺎطﺔﻓﺋﺔاﻟﺳﺟل.??ﻣﺛﺎل: ﺣﻘلاﻟﻧوعاﻻﺟﺗﻣﺎﻋﻲ،ﻣﻊﻣﺗﻐﯾرﯾنﻓﻘط)ذﻛروأﻧﺛﻰ(??ﻣﺛﺎل: ﺣﻘلاﻟوﺻف ﻓﻲاﻟﺷراﺋﺢاﻟﺳﺎﺑﻘﺔ،ﻣﻊاﻟﻌدﯾدﻣناﻟﻣﺗﻐﯾرات(ﻣﺛلADVIL ،TYLENOL X / STRGTH LIQ).?اﻟﺑﯾﺎﻧﺎتاﻟﺗرﺗﯾﺑﯾﺔ،ﺗﺣددأﯾﺿًﺎﻓﺋﺔاﻟﺳﺟلوﻟﻛنﺑﺗرﺗﯾبطﺑﯾﻌﻲﻟﻠﻘﯾم.??ﻣﺛﺎل: ﻣرﺗﻔﻊوﻣﺗوﺳطوﻣﻧﺧﻔض??ﻣﺛﺎل: اﻟﺗرﺗﯾباﻟﻌددي،ﺣﯾث5= اﻷﻛﺛرﺗﻔﺿﯾﻼً،1= اﻷﻗلﺗﻔﺿﯾﻼً
TYPES OF DATA: NUMERICAL DATA?Interval data, which conveys a sense of the difference between values. ?Example: The Fahrenheit scale.?Ratio data, based on a scale with a meaningful zero point.?Example: Monetary units, ages.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.146?اﻟﺑﯾﺎﻧﺎتاﻟﻔﺎﺻﻠﺔ،اﻟﺗﻲﺗﻧﻘلاﻹﺣﺳﺎسﺑﺎﻟﻔرقﺑﯾناﻟﻘﯾم.??ﻣﺛﺎل:ﻣﻘﯾﺎسﻓﮭرﻧﮭﺎﯾت.?ﺑﯾﺎﻧﺎتاﻟﻧﺳﺑﺔ،ﺑﻧﺎءًﻋﻠﻰﻣﻘﯾﺎسﺑﻧﻘطﺔاﻟﺻﻔرذاتﻣﻐزى.??ﻣﺛﺎل:اﻟوﺣداتاﻟﻧﻘدﯾﺔواﻷﻋﻣﺎر.
DATA EXPLORATION?Databases are highly structured for storage but do not automatically reveal patterns and insights. ?We exploredatabases in a five-step process:1.Understand the data2.Organize and subset the database3.Examine individual variables and their distributions4.Calculate summary measures for individual variables5.Examine relationships among variablesChapter 5Copyright ? 2013 John Wiley & Sons, Inc.147?ﻗواﻋداﻟﺑﯾﺎﻧﺎتﻣﻧظﻣﺔﻟﻠﻐﺎﯾﺔﻟﻠﺗﺧزﯾنوﻟﻛﻧﮭﺎﻻﺗﻛﺷفﺗﻠﻘﺎﺋﯾًﺎﻋناﻷﻧﻣﺎطواﻟرؤى.?ﻧﺳﺗﻛﺷفﻗواﻋداﻟﺑﯾﺎﻧﺎتﻓﻲﻋﻣﻠﯾﺔﻣنﺧﻣسﺧطوات:.1اﻓﮭماﻟﺑﯾﺎﻧﺎت.2ﺗﻧظﯾموﻗﺎﻋدةاﻟﺑﯾﺎﻧﺎتاﻟﻔرﻋﯾﺔ.3ﻓﺣصاﻟﻣﺗﻐﯾراتاﻟﻔردﯾﺔوﺗوزﯾﻌﮭﺎ.4ﺣﺳﺎباﻟﻣﻘﺎﯾﯾساﻟﻣوﺟزةﻟﻠﻣﺗﻐﯾراتاﻟﻔردﯾﺔ.5اﻓﺣصاﻟﻌﻼﻗﺎتﺑﯾناﻟﻣﺗﻐﯾرات
UNDERSTAND THE DATA?Be skeptical of data, and ask: ?How are fields defined??What types of data are represented? ?What units are the data in? ?Example: Job applicants database?SEX and AGE are unambiguous, but, does CITZ CODE (with U for US, N for non-US) represent country of birth? Or citizenship? Where the applicant currently lives? Know how the variable was coded.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.148?ﻛنﻣﺗﺷﻛﻛًﺎﻓﻲاﻟﺑﯾﺎﻧﺎت،واﺳﺄل:??ﻛﯾفﯾﺗمﺗﻌرﯾفاﻟﺣﻘول؟??ﻣﺎأﻧواعاﻟﺑﯾﺎﻧﺎتاﻟﻣﻣﺛﻠﺔ؟??ﻣﺎھﻲاﻟوﺣداتاﻟﺗﻲﺗﺣﺗويﻋﻠﯾﮭﺎاﻟﺑﯾﺎﻧﺎت؟?ﻣﺛﺎل: ﻗﺎﻋدةﺑﯾﺎﻧﺎتاﻟﻣﺗﻘدﻣﯾنﻟﻠوظﺎﺋف-اﻟﺟﻧسواﻟﻌﻣرﻻﻟﺑسﻓﯾﮭﻣﺎ،وﻟﻛنھلﯾﻣﺛل)CITZ CODE ﻣﻊUﻟﻠوﻻﯾﺎتاﻟﻣﺗﺣدةوNﻟﻐﯾراﻟوﻻﯾﺎتاﻟﻣﺗﺣدة( ﺑﻠداﻟﻣﯾﻼد؟أماﻟﻣواطﻧﺔ؟اﯾنﯾﻌﯾشاﻟﻣﺗﻘدمﺣﺎﻟﯾﺎ؟اﻋرفﻛﯾفﺗمﺗرﻣﯾزاﻟﻣﺗﻐﯾر.
ORGANIZE AND SUBSET THE DATABASE?Two essential tools: Sort and Filter?On the Home ribbon in the Editing group and the Data Ribbon in the Sort and Filter group?Question: In the Executives database below, do any duplicate records (EXECID) appear? Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.149?أداﺗﺎنأﺳﺎﺳﯾﺗﺎن: اﻟﻔرزواﻟﺗﺻﻔﯾﺔ??ﻋﻠﻰاﻟﺷرﯾطاﻟرﺋﯾﺳﻲﻓﻲﻣﺟﻣوﻋﺔاﻟﺗﺣرﯾروﺷرﯾطاﻟﺑﯾﺎﻧﺎتﻓﻲﻣﺟﻣوﻋﺔاﻟﻔرزواﻟﺗﺻﻔﯾﺔ?ﺳؤال: ﻓﻲﻗﺎﻋدةﺑﯾﺎﻧﺎتاﻟﺗﻧﻔﯾذﯾﯾنأدﻧﺎه،ھلﺗظﮭرأيﺳﺟﻼتﻣﻛررة(EXECID)؟
ORGANIZE AND SUBSET THE DATABASE (CONTD)?Home??Editing??Sort & Filter??Custom Sort opens the Sort window ?We sort by the EXECID column, sort on Values, and in order of A to Z, and click OK. ?We can then scan for duplicate numbers (which appear above one another)Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.150?اﻟﺻﻔﺣﺔاﻟرﺋﯾﺳﯾﺔ< ﺗﺣرﯾر< اﻟﻔرزواﻟﺗﺻﻔﯾﺔ<اﻟﻔرزاﻟﻣﺧﺻصﯾﻔﺗﺢﻧﺎﻓذةاﻟﻔرز??ﻧﻘومﺑﺎﻟﻔرزﺣﺳبﻋﻣودEXECID ،واﻟﻔرزﺣﺳباﻟﻘﯾم،وﻣناﻷﻟفإﻟﻰاﻟﯾﺎء،واﻧﻘرﻓوقﻣواﻓق.??ﯾﻣﻛﻧﻧﺎﺑﻌدذﻟكاﻟﺑﺣثﻋنأرﻗﺎمﻣﻛررة)ﺗظﮭرﻓوقﺑﻌﺿﮭﺎاﻟﺑﻌض(
ORGANIZE AND SUBSET THE DATABASE (CONTD)?We can sort by more than one criterion using Add Level, for example: ?ROUND then INDUSTRY then JOB MONTHS?But, ties on the first criterion will be broken by the second, and the second by the third.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.151?ﯾﻣﻛﻧﻧﺎاﻟﻔرزﺣﺳبأﻛﺛرﻣنﻣﻌﯾﺎرﺑﺎﺳﺗﺧدام"إﺿﺎﻓﺔﻣﺳﺗوى" ،ﻋﻠﻰﺳﺑﯾلاﻟﻣﺛﺎل:??اﻟﺟوﻟﺔﺛماﻟﺻﻧﺎﻋﺔﺛماﻷﺷﮭراﻟوظﯾﻔﯾﺔ??وﻟﻛن،ﺳﯾﺗمﻛﺳراﻟﻌﻼﻗﺎتﻋﻠﻰاﻟﻣﻌﯾﺎراﻷولﺑﺎﻟﺛﺎﻧﻲ،واﻟﺛﺎﻧﻲﺑﺎﻟﺛﺎﻟث.
ORGANIZE AND SUBSET THE DATABASE: FILTERING?Filtering allows us to probe a large database and extract what interests us.?Example: In Applicants database, what are the characteristics of applicants from nonprofit organizations? ?Home??Editing??Sort & Filter??Filter. Click on Industry Description, and uncheck Select All, then check Nonprofit.?Does not delete other records, only hides themChapter 5Copyright ? 2013 John Wiley & Sons, Inc.152?ﺗﺗﯾﺢﻟﻧﺎاﻟﺗﺻﻔﯾﺔﻓﺣصﻗﺎﻋدةﺑﯾﺎﻧﺎتﻛﺑﯾرةواﺳﺗﺧراجﻣﺎﯾﮭﻣﻧﺎ.?ﻣﺛﺎل: ﻓﻲﻗﺎﻋدةﺑﯾﺎﻧﺎتاﻟﻣﺗﻘدﻣﯾن،ﻣﺎھﻲﺧﺻﺎﺋصاﻟﻣﺗﻘدﻣﯾنﻣناﻟﻣﻧظﻣﺎتﻏﯾراﻟرﺑﺣﯾﺔ؟?اﻟﺻﻔﺣﺔاﻟرﺋﯾﺳﯾﺔ< ﺗﺣرﯾر< اﻟﻔرزواﻟﺗﺻﻔﯾﺔ< ﻓﻠﺗر. اﻧﻘرﻋﻠﻰ"وﺻفاﻟﺻﻧﺎﻋﺔ" ،وأﻟﻎﺗﺣدﯾد"ﺗﺣدﯾداﻟﻛل" ،ﺛمﺗﺣﻘقﻣن"ﻣؤﺳﺳﺔﻏﯾررﺑﺣﯾﺔ".?ﻻﯾﺣذفاﻟﺳﺟﻼتاﻷﺧرى،ﺑلﯾﺧﻔﯾﮭﺎﻓﻘط
EXAMINE INDIVIDUAL VARIABLES AND THEIR DISTRIBUTION?For numerical variables, we typically want to know the range of records from lowest to highest, and areas where most outcomes lie.?Example: In Applicants database, what are typical values for JOB MONTHS and what is the range from lowest to highest??A common way to summarize a set of numerical values is the histogram, although Excel provides eight choices. Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.153?ﺑﺎﻟﻧﺳﺑﺔﻟﻠﻣﺗﻐﯾراتاﻟﻌددﯾﺔ،ﻧرﯾدﻋﺎدةًﻣﻌرﻓﺔﻧطﺎقاﻟﺳﺟﻼتﻣناﻷﻗلإﻟﻰاﻷﻋﻠﻰ،واﻟﻣﺟﺎﻻتاﻟﺗﻲﺗﻘﻊﻓﯾﮭﺎﻣﻌظماﻟﻧﺗﺎﺋﺞ.?ﻣﺛﺎل: ﻓﻲﻗﺎﻋدةﺑﯾﺎﻧﺎتاﻟﻣﺗﻘدﻣﯾن،ﻣﺎھﻲاﻟﻘﯾماﻟﻧﻣوذﺟﯾﺔﻟﺷﮭورJOB وﻣﺎھواﻟﻧطﺎقﻣناﻷدﻧﻰإﻟﻰاﻷﻋﻠﻰ؟?اﻟطرﯾﻘﺔاﻟﺷﺎﺋﻌﺔﻟﺗﻠﺧﯾصﻣﺟﻣوﻋﺔﻣناﻟﻘﯾماﻟﻌددﯾﺔھﻲاﻟرﺳماﻟﺑﯾﺎﻧﻲ،ﻋﻠﻰاﻟرﻏمﻣنأنExcelﯾوﻓرﺛﻣﺎﻧﯾﺔﺧﯾﺎرات.
EXAMINE INDIVIDUAL VARIABLES AND THEIR DISTRIBUTION (CONTD)?In XLMiner add-in, choose Explore??Chart Wizard, and the screen at top right appears.?In subsequent windows choose Frequency for Y axis, JOB MONTHS for X axis, and the histogram at bottom right appears.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.154?ﻓﻲاﻟوظﯾﻔﺔاﻹﺿﺎﻓﯾﺔXLMiner ،اﺧﺗرExplore??Chart Wizard ،وﺳﺗظﮭراﻟﺷﺎﺷﺔﻓﻲأﻋﻠﻰاﻟﯾﻣﯾن.?ﻓﻲاﻟﻧواﻓذاﻟﺗﺎﻟﯾﺔ،اﺧﺗراﻟﺗرددﻟﻠﻣﺣورY ،وJOB MONTHS ﻟﻠﻣﺣورX ،وﯾظﮭراﻟرﺳماﻟﺑﯾﺎﻧﻲﻓﻲأﺳﻔلاﻟﯾﻣﯾن.
CALCULATE SUMMARY MEASURES FOR INDIVIDUAL VARIABLES (CONTD)?Excel provides numerous functions useful for investigating individual variables. ?Some can summarize the values of numerical variables; others can be used to identify or count specific variables, both numerical and categorical. ?Example: What is the average age in the Applicants database?Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.155?ﯾوﻓرExcel اﻟﻌدﯾدﻣناﻟوظﺎﺋفاﻟﻣﻔﯾدةﻟﻠﺗﺣﻘﯾقﻓﻲاﻟﻣﺗﻐﯾراتاﻟﻔردﯾﺔ.?ﯾﻣﻛنﻟﻠﺑﻌضأنﯾﻠﺧصﻗﯾماﻟﻣﺗﻐﯾراتاﻟﻌددﯾﺔ؛ﯾﻣﻛناﺳﺗﺧداماﻟﺑﻌضاﻵﺧرﻟﺗﺣدﯾدأوﺣﺳﺎبﻣﺗﻐﯾراتﻣﻌﯾﻧﺔ،ﺳواءاﻟﻌددﯾﺔأواﻟﻔﺋوﯾﺔ.?ﻣﺛﺎل: ﻣﺎھوﻣﺗوﺳطاﻟﻌﻣرﻓﻲﻗﺎﻋدةﺑﯾﺎﻧﺎتاﻟﻣﺗﻘدﻣﯾن؟
CALCULATE SUMMARY MEASURES FOR INDIVIDUAL VARIABLES?The most common summary measure of a numerical value is average or mean. ?Calculate using the AVERAGE function in Excel, for example: AVERAGE (C2:C2918) = 28.97?Other useful summary measures are median, minimum, maximum. Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.156?اﻟﻣﻘﯾﺎساﻷﻛﺛرﺷﯾوﻋًﺎﻟﻠﻘﯾﻣﺔاﻟﻌددﯾﺔھواﻟﻣﺗوﺳطأواﻟﻣﺗوﺳط.?اﺣﺳبﺑﺎﺳﺗﺧدامداﻟﺔAVERAGE ﻓﻲExcel ،ﻋﻠﻰﺳﺑﯾلاﻟﻣﺛﺎل:ﻣﺗوﺳط(C2: C2918) = 28.97?اﻟﻣﻘﺎﯾﯾساﻟﻣوﺟزةاﻟﻣﻔﯾدةاﻷﺧرىھﻲﻣﺗوﺳط،اﻟﺣداﻷدﻧﻰ،اﻟﺣداﻷﻗﺻﻰ.
EXAMINE RELATIONSHIPS AMONG VARIABLES?In many cases relationships among variables are more important in analysis than the properties of one variable. ?Graphical methods can track relationships. ?Example: How long have older applicants held their current jobs?Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.157?ﻓﻲﻛﺛﯾرﻣناﻟﺣﺎﻻتﺗﻛوناﻟﻌﻼﻗﺎتﺑﯾناﻟﻣﺗﻐﯾراتأﻛﺛرأھﻣﯾﺔﻓﻲاﻟﺗﺣﻠﯾلﻣنﺧﺻﺎﺋصﻣﺗﻐﯾرواﺣد.?ﯾﻣﻛنﻟﻠطرقاﻟرﺳوﻣﯾﺔﺗﺗﺑﻊاﻟﻌﻼﻗﺎت.?ﻣﺛﺎل: إﻟﻰﻣﺗﻰﯾﺣﺗﻔظاﻟﻣﺗﻘدﻣوناﻷﻛﺑرﺳﻧًﺎﺑوظﺎﺋﻔﮭماﻟﺣﺎﻟﯾﺔ؟
EXAMINE RELATIONSHIPS AMONG VARIABLES (CONTD)?Use XLMiner to create a scatterplot between AGE and JOB MONTHS in the Applicants database.?Select Explore??Chart Wizard??Scatterplot Matrix.?Select variables AGE and JOB MONTHS, then click Finish for results at right.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.158?اﺳﺗﺧدمXLMiner ﻹﻧﺷﺎءﻣﺧططﻣﺑﻌﺛرﺑﯾنAGE وJOB MONTHSﻓﻲﻗﺎﻋدةﺑﯾﺎﻧﺎتاﻟﻣﺗﻘدﻣﯾن.?ﺣددExplore??Chart Wizard??Scatterplot Matrix.?ﺣدداﻟﻣﺗﻐﯾراتAGE وJOB MONTHS ،ﺛماﻧﻘرﻓوقإﻧﮭﺎءﻟﻠﻧﺗﺎﺋﺞﻋﻠﻰاﻟﯾﻣﯾن.
EXAMINE RELATIONSHIPS AMONG VARIABLES (CONTD)?Relationships may be more complex, based on numerous variables. ?Example: How does the distribution of GMAT scores of applicants compare across the five application rounds??This asks us to compare five distributions, each with considerable information. ?Boxplot option in XLMiner can generate a chart summarizing numerous statistics (e.g., mean, median). ?Select Explore??Chart Wizard??Boxplot select variables GMAT and ROUND, click Finish.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.159?ﻗدﺗﻛوناﻟﻌﻼﻗﺎتأﻛﺛرﺗﻌﻘﯾدًا،ﺑﻧﺎءًﻋﻠﻰﻣﺗﻐﯾراتﻋدﯾدة.??ﻣﺛﺎل: ﻛﯾفﯾﻘﺎرنﺗوزﯾﻊدرﺟﺎتGMAT ﻟﻠﻣﺗﻘدﻣﯾنﻋﺑرﺟوﻻتاﻟﺗﻘدﯾماﻟﺧﻣس؟?ھذاﯾطﻠبﻣﻧﺎأنﻧﻘﺎرنﺑﯾنﺧﻣﺳﺔﺗوزﯾﻌﺎت،ﻛلﻣﻊﻣﻌﻠوﻣﺎتﻛﺑﯾرة.?ﯾﻣﻛنﻟﺧﯾﺎرBoxplotﻓﻲXLMiner إﻧﺷﺎءﻣﺧططﯾﻠﺧصاﻟﻌدﯾدﻣناﻹﺣﺻﺎﺋﯾﺎت)ﻋﻠﻰﺳﺑﯾلاﻟﻣﺛﺎل،ﻣﺗوﺳط،ﻣﺗوﺳط(.?ﺣددExplore??Chart Wizard??Boxplot ﺣدداﻟﻣﺗﻐﯾراتGMAT وROUND،اﻧﻘرﻓوقإﻧﮭﺎء.
SUMMARY?The ability to use data intelligently is a vital skill for business analysts. ?Analysts tend to perform most of their analysis in Excel. ?Understanding the data is the most important step, before undertaking any analysis. ?Careful preparation of raw data is often required before data mining can succeed. ?Missing values may have to be removed or replaced with average values. ?Numerical variables may need to be converted to categorical values (or vice versa). ?Normalization of data may be required.Chapter 5Copyright ? 2013 John Wiley & Sons, Inc.160?ﺗﻌداﻟﻘدرةﻋﻠﻰاﺳﺗﺧداماﻟﺑﯾﺎﻧﺎتﺑذﻛﺎءﻣﮭﺎرةﺣﯾوﯾﺔﻟﻣﺣﻠﻠﻲاﻷﻋﻣﺎل.?ﯾﻣﯾلاﻟﻣﺣﻠﻠونإﻟﻰإﺟراءﻣﻌظمﺗﺣﻠﯾﻼﺗﮭمﻓﻲExcel.?ﯾﻌﺗﺑرﻓﮭماﻟﺑﯾﺎﻧﺎتأھمﺧطوةﻗﺑلإﺟراءأيﺗﺣﻠﯾل.?ﻏﺎﻟﺑًﺎﻣﺎﯾﻛوناﻹﻋداداﻟدﻗﯾقﻟﻠﺑﯾﺎﻧﺎتاﻷوﻟﯾﺔﻣطﻠوﺑًﺎﻗﺑلأنﯾﻧﺟﺢاﺳﺗﺧراجاﻟﺑﯾﺎﻧﺎت.??ﻗدﯾﺗﻌﯾنإزاﻟﺔاﻟﻘﯾماﻟﻣﻔﻘودةأواﺳﺗﺑداﻟﮭﺎﺑﻣﺗوﺳطاﻟﻘﯾم.??ﻗدﺗﺣﺗﺎجاﻟﻣﺗﻐﯾراتاﻟﻌددﯾﺔإﻟﻰﺗﺣوﯾلإﻟﻰﻗﯾمﻓﺋوﯾﺔ)أواﻟﻌﻛس(.??ﻗدﺗﻛونھﻧﺎكﺣﺎﺟﺔإﻟﻰﺗطﺑﯾﻊاﻟﺑﯾﺎﻧﺎت.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.