Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Struttura del corso
Aggregazione dei Dati in Excel
- Funzioni Statistiche
- Schema di Riassunto
- Sottototali
- Tabella Pivot
Analisi delle Relazioni dei Dati
- Distribuzione Normale
- Descrittive Statistics
- Correlazione Lineare
- Analisi di Regressione
- Covarianza
Analisi dei Dati nel Tempo
- Tendenze/Retta di Regressione
- Smussatura Lineare, Logaritmica, Polinomiale, Potenza, Esponenziale, Media Mobile
- Analisi delle Fluttuazioni Stagionali
Confronto di Popolazioni
- Intervallo di Confidenza per la Media
- Test dell'Ippotesi sulla Media della Popolazione
- Differenza tra le Medie di Due Popolazioni
- ANOVA: Analisi delle Varianze
- Gotest del Buon Adattamento per Variabili Aleatorie Discrete
- Test di Indipendenza: Tabelle di Contingenza
- Test dell'Ippotesi sulla Varianza tra Due Popolazioni
Forecasting
- Estrapolazione
Requisiti
I partecipanti dovrebbero essere familiarizzati con le basi di Excel e Statistics.
14 ore
Recensioni (3)
1. Clear theoretical explanation of concepts and alternatives to problem solving. 2. Practical examples where concepts are, and can be applied. 3. I learnt skills that I can use in my job, which will make some of my work easier 4. It will definitely bring some innovation into some of the reports I prepare for different Committees.
Sindiso Ndlovu - Export Credit insurance corporation
Corso - Excel For Statistical Data Analysis
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
Corso - Excel For Statistical Data Analysis
The fact he had dif excel and data sheets with exercises for us to do.
