Análisi de Dades en Psicologia. Dossier d'ordinadors: l'Excel

A portada: Primer curs-Primer i segon semestre[eng] This document intends to provide the user with necessary tools to develop a basic statistical analysis through a Microsoft Excel spreadsheet. The two first sections deal with basic procedures to use the program as a spreadsheet, organise and create a data matrix. Sections three, four and five describe how to proceed in order to carry out a descriptive analysis of qualitative and quantitative variables, both from a univariant and bivariant approach. In the rest of sections reference is made to the necessary instructions to perform different tests under the framing of inferential statistics, as well as how to calculate statistical significance from different statistical figures.[cat] El present document pretén donar les eines bàsiques per tal que l'usuari pugui realitzar una anàlisi estadística bàsica a partir del full de càlcul Microsoft Excel. Ens els dos primers apartats es fa referència als procediments bàsics per utilitzar el programa com a full de càlcul, organitzar i crear una matriu dades. Els apartats tres, quatre i cinc descriuen com procedir per portar a terme una anàlisi descriptiva de variables qualitatives i quantitatives, tant des de la vessant univariant com bivariant. En els restants apartats es fa referència a les instruccions necessàries per realitzar diferents proves dins del marc de l'estadística inferencial així com calcular la significació estadística dels diferents estadístics.[spa] El presente documento pretende ofrecer las herramientas básicas para que el usuario pueda realizar un análisis estadístico básico a partir de la hoja de cálculo de Microsoft Excel. En los dos primeros apartados se hace referencia a los procedimientos básicos para utilizar el programa como hoja de cálculo, organizar y crear una matriz de datos. Los apartados tres cuatro y cinco describen como proceder para llevar a cabo un análisis descriptivo de variables cualitativas y cuantitativas, tanto des del enfoque univariante como bivariante. En los restantes apartados se hace referencia a las instrucciones necesarias para realizar distintas pruebas dentro del marco de la estadística inferencial, así como calcular la significación estadística de los diferentes estadísticos

Análisis territorial de los aprovechamientos agrícolas del Camín Real de la mesa, Asturias: Territorial analysis of agricultural use of Camin Real de la mesa, Asturias

Dentro de la España Verde, un territorio de unos 23.200 Km2 con una elevada productividad natural, el área conocida como Camín Real de la Mesa (CRM) ocupa la zona central de la Comunidad Autónoma de Asturias (norte de España), con una extensión de 1.400 Km2. El Grupo de Desarrollo Rural del Camín Real de la Mesa encargó este estudio, con el objetivo de tener un documento técnico para desarrollar el Plan Estratégico 2014-2020 de la Unión Europea (UE). Este objetivo es coherente con las estrategias de la política de la UE para el desarrollo del medio rural, particularmente con las del EJE 1: aumento de la competitividad del sector agrícola y forestal. En esta comarca, de uso tradicional ganadero desde hace miles de años, está muy poco aprovechada su capacidad de producción hortofrutícola, perdiéndose así un gran potencial económico, muy necesario para la comarca. La metodología aplicada se basa en los procedimientos clásicos de la Ordenación Territorial y el uso de técnicas de análisis espacial, mediante un Sistema de Información Geográfica (SIG), con el que se integró información procedente de distintos mapas de componentes del medio físico: Pendientes, Altitudes y Orientaciones topográficas, obtenidas a partir de un modelo digital de elevaciones del terreno (MDE) –con una precisión de 5 metros–,  Litología y Depósitos superficiales, Suelos, Vegetación y Usos Actuales del Territorio, y, finalmente, Parámetros Climáticos, como la Insolación Potencial, Temperaturas, Coeficientes hídricos, etc. A estas bases de datos espaciales se han incorporado los datos históricos existentes sobre los cultivos que había en el CRM en el siglo XIX, según el inventario realizado por Madoz en el año 1850. Integrar y evaluar  todos estos elementos da los resultados siguientes para el territorio del Camín Real de La Mesa: - Una cartografía por Concejos (Municipios) de los usos agrícolas existentes allí en el año 1850. - Un mapa de Orientación de Usos óptimos a escala 1:25.000, que incluye los siguientes usos: Agrícola intensivo, Ganadería intensiva, Ganadería extensiva, Forestal de producción, Forestal de conservación, Conservación de la Biodiversidad, Ganadería extensiva/Conservación de la Biodiversidad, e Improductivo. - Una cartografía a escala 1:5.000 de los terrenos de mayor Aptitud de Uso para  16 tipos de cultivos hortofrutícolas.&nbsp

SMOS REFLEX 2003: L-Band Emissivity Characterization of Vineyards

The goal of the Soil Moisture and Ocean Salinity mission over land is to infer surface soil moisture from multiangular L-band radiometric measurements. As the canopy affects the microwave emission of land, it is necessary to characterize different vegetation layers. This paper presents the Reference Pixel L-Band Experiment (REFLEX), carried out in June-July 2003 at the Vale/spl grave/ncia Anchor Station, Spain, to study the effects of grapevines on the soil emission and on the soil moisture retrieval. A wide range of soil moisture (SM), from saturated to completely dry soil, was measured with the Universitat Polite/spl grave/cnica de Catalunya's L-band Automatic Radiometer (LAURA). Concurrently with the radiometric measurements, the gravimetric soil moisture, temperature, and roughness were measured, and the vines were fully characterized. The opacity and albedo of the vineyard have been estimated and found to be independent on the polarization. The /spl tau/--/spl omega/ model has been used to retrieve the SM and the vegetation parameters, obtaining a good accuracy for incidence angles up to 55/spl deg/. Algorithms with a three-parameter optimization (SM, albedo albedo, and opacity) exhibit a better performance than those with one-parameter optimization (SM).Peer Reviewe

SMOS REFLEX 2003: L-band emissivity characterization of vineyards

The goal of the Soil Moisture and Ocean Salinity mission over land is to infer surface soil moisture from multiangular L-band radiometric measurements. As the canopy affects the microwave emission of land, it is necessary to characterize different vegetation layers. This paper presents the Reference Pixel L-Band Experiment (REFLEX), carried out in June-July 2003 at the Vale/spl grave/ncia Anchor Station, Spain, to study the effects of grapevines on the soil emission and on the soil moisture retrieval. A wide range of soil moisture (SM), from saturated to completely dry soil, was measured with the Universitat Polite/spl grave/cnica de Catalunya's L-band Automatic Radiometer (LAURA). Concurrently with the radiometric measurements, the gravimetric soil moisture, temperature, and roughness were measured, and the vines were fully characterized. The opacity and albedo of the vineyard have been estimated and found to be independent on the polarization. The /spl tau--//spl omega/ model has been used to retrieve the SM and the vegetation parameters, obtaining a good accuracy for incidence angles up to 55/spl deg/. Algorithms with a three-parameter optimization (SM, albedo albedo, and opacity) exhibit a better performance than those with one-parameter optimization (SM).Peer Reviewe

Adaptation and validation of the Spanish version of the patient-oriented prostate utility scale (PORPUS)

Objective: the Patient-Oriented Prostate Utility Scale (PORPUS) is a combined profile and utility-based quality of life measure for prostate cancer patients. Our objectives were to adapt the PORPUS into Spanish and to assess its acceptability, reliability, and validity. Methods: the PORPUS was adapted into Spanish using forward and back translations and cognitive debriefing. PORPUS was administered jointly with the SF-36 and the Expanded Prostate Index Composite (EPIC) to 480 Spanish prostate cancer patients treated with radical prostatectomy or radiotherapy. The Spanish PORPUS scores' distribution and reliability were examined and compared with the original instrument. To evaluate construct validity, relationships were assessed between PORPUS and other instruments (testing hypotheses of the original PORPUS study), and among known groups defined by side effect severity. Results: reliability coefficient was 0.76 (similar to the original PORPUS' 0.81). Spanish PORPUS items presented correlations ranging 0.57-0.88 with the corresponding EPIC domains, as in the original PORPUS study (0.60-0.83). Both PORPUS-P and PORPUS-U showed significant differences and large effect sizes (0.94-1.90) when comparing severe versus no problem groups on urinary, bowel, sexual and hormonal side effects defined by EPIC. Conclusions: a conceptually equivalent Spanish version was obtained, with high reliability and good construct validity, similar to the original Canadian PORPUS version. It can therefore be used to measure health-related quality of life and utilities in Spanish prostate cancer patients

Comparación de costes de tres tratamientos del cáncer de próstata localizado en España : prostatectomía radical, braquiterapia prostática y radioterapia conformacional externa 3D

Altres ajuts: AATM/086/24/2000Objetivo: comparar los costes de los tratamientos más establecidos para el cáncer de próstata localizado según grupos de riesgo, edad y comorbilidad, desde la perspectiva del proveedor asistencial. Métodos: comparación de costes en pacientes reclutados consecutivamente entre 2003 y 2005 en una unidad funcional de tratamiento del cáncer de próstata. La utilización de servicios hasta 6 meses después del inicio del tratamiento se obtuvo de las bases de datos hospitalarias, y los costes directos se estimaron mediante cálculo microcoste. La información sobre las características clínicas de los pacientes y los tratamientos recogió prospectivamente. Los costes se compararon mediante tests no paramétricos de comparación de medianas (Kruskall-Wallis) y un modelo semilogarítmico de regresión múltiple. Resultados: la diferencia de costes fue estadísticamente significativa: medianas de 3229.10D, 5369.00Dy 6265.60D para los pacientes tratados con radioterapia conformacional externa 3D, braquiterapia, y prostatectomía radical retro pública, respectivamente (p <0,001). En el análisis multivariado (R2 ajustada=0,8), los costes medios de la braquiterapia y de la radioterapia externa fueron significativamente menores que los de la prostatectomía (coeficiente -0,212 y -0,729, respectivamente). Conclusiones: la prostatectomía radical resultó ser la opción terapéutica de mayor coste. En general, los costes estimados en nuestro estudio son inferiores a los publicados en otros ámbitos. La opción terapéutica explica gran parte de los costes, y tanto la comorbilidad como el grupo de riesgo no mostraron efecto independiente del tratamiento sobre los costes totales.Objective: To compare the initial costs of the three most established treatments for clinically localized prostate cancer according to risk, age and comorbidity groups, from the healthcare provider's perspective. Methods: We carried out a cost comparison study in a sample of patients consecutively recruited between 2003 and 2005 from a functional unit for prostate cancer treatment in Catalonia (Spain). The use of services up to 6 months after the treatment start date was obtained from hospital databases and direct costs were estimated by micro-cost calculation. Information on the clinical characteristics of patients and treatments was collected prospectively. Costs were compared by using nonparametric tests comparing medians (Kruskall-Wallis) and a semi-logarithmic multiple regression model. Results: Among the 398 patients included, the cost difference among treatments was statistically significant: medians were €3,229.10, €5,369.00 and €6,265.60, respectively, for the groups of patients treated with external 3D conformal radiotherapy, brachytherapy and radical retropublic prostatectomy, (p<0.001). In the multivariate analysis (adjusted R=0.8), the average costs of brachytherapy and external radiotherapy were significantly lower than that of prostatectomy (coefficient -0.212 and -0.729, respectively). Conclusions: Radical prostatectomy proved to be the most expensive treatment option. Overall, the estimated costs in our study were lower than those published elsewhere. Most of the costs were explained by the therapeutic option and neither comorbidity nor risk groups showed an effect on total costs independent of treatment

Consensus on post COVID in the Spanish national health system: Results of the CIBERPOSTCOVID eDelphi study

Background: In 2021, the Spanish Ministry of Health launched the CIBERPOSTCOVID project to establish what post COVID was. The present study reports the level of agreement among stakeholders on post COVID and its clinical and diagnostic characteristics in the Spanish health system. Methods: The agreement on post COVID among clinicians, public health managers, researchers and patients' representatives was explored in a real-time, asynchronous online Delphi. In a two-wave consensus, respondents rated from 1 (total disagreement) to 6 (total agreement) 67 statements related to terminology, duration, etiology, symptoms, impact on quality of life, severity, elements to facilitate diagnosis, applicability in the pediatric population, and risk factors. Consensus was reached when 70 % of ratings for a statement were 5 or 6, with an interquartile range equal or less than 1. Findings: A total of 333 professionals and patients participated in this eDelphi study. There was agreement that post COVID was "a set of multi-organic symptoms that persist or fluctuate after acute COVID-19 infection and are not attributable to other causes" with a minimum duration of 3 months. The highest levels of agreement were found in the most frequent symptoms and its impacts on everyday activities. Aspects related to the diagnostic process and the measurement of its severity reached a lower level of consensus. There was agreement on the need to rule out previous health problems and assess severity using validated functional scales. However, no agreement was reached on the risk factors or specific features in the pediatric population. Interpretation: This policy-based consensus study has allowed the characterization of post COVID generating collective intelligence and has contributed to an operational definition applicable in clinical practice, health services management and useful for research purposes in Spain and abroad. Agreements are consistent with existing evidence and reference institutions at European and international level.The CIBERPOSTCOVID is a commissioned project of the Spanish Ministry of Health to the Ministry of Science and Innovation, funded through the Instituto de Salud Carlos III and CIBER -Consorcio Centro de Investigación Biomédica en Red- (ES21PI01).S

Gene expression profiling identifies molecular pathways associated with collagen VI deficiency and provides novel therapeutic targets

Ullrich congenital muscular dystrophy (UCMD), caused by collagen VI deficiency, is a common congenital muscular dystrophy. At present, the role of collagen VI in muscle and the mechanism of disease are not fully understood. To address this we have applied microarrays to analyse the transcriptome of UCMD muscle and compare it to healthy muscle and other muscular dystrophies. We identified 389 genes which are differentially regulated in UCMD relative to controls. In addition, there were 718 genes differentially expressed between UCMD and dystrophin deficient muscle. In contrast, only 29 genes were altered relative to other congenital muscular dystrophies. Changes in gene expression were confirmed by real-time PCR. The set of regulated genes was analysed by Gene Ontology, KEGG pathways and Ingenuity Pathway analysis to reveal the molecular functions and gene networks associated with collagen VI defects. The most significantly regulated pathways were those involved in muscle regeneration, extracellular matrix remodelling and inflammation. We characterised the immune response in UCMD biopsies as being mainly mediated via M2 macrophages and the complement pathway indicating that anti-inflammatory treatment may be beneficial to UCMD as for other dystrophies. We studied the immunolocalisation of ECM components and found that biglycan, a collagen VI interacting proteoglycan, was reduced in the basal lamina of UCMD patients. We propose that biglycan reduction is secondary to collagen VI loss and that it may be contributing towards UCMD pathophysiology. Consequently, strategies aimed at over-expressing biglycan and restore the link between the muscle cell surface and the extracellular matrix should be considered

External eating as a predictor of cue-reactivity to food-related virtual environments

The objective of this study was to assess the association between external eating style and food craving experienced during exposure to food cues in virtual reality (VR) environments in both clinical and non-clinical samples. According to the externality theory, people with external eating experience higher reactivity when exposed to food cues, which in turn increases the probability of overeating. Forty patients with eating disorders (23 with bulimia nervosa and 17 with binge eating disorder) and 78 undergraduate students were exposed to 10 different food cues in four VR environments (kitchen, dining room, bedroom, and café). After 30 seconds of exposure to each VR environment, food craving was assessed using a visual analog scale. External, emotional and restrictive eating styles were also assessed using the DEBQ. The results showed a strong association between external eating and cue-elicited food craving. After controlling for the presence of eating disorder diagnosis, external eating was the best predictor of reported food craving. The results lend support to the externality theory but highlight the need for further research in specific patterns of functioning in patients with bulimia nervosa and binge eating disorder

Eating behavior style predicts craving and anxiety experienced in food-related virtual environments by patients with eating disorders and healthy controls

Eating behavior style (emotional, restrictive, or external) has been proposed as an explanation for the differences in response to food-related cues between people who overeat and those who do not, and has been also considered a target for the treatment of eating disorders (EDs) characterized by lack of control over eating and weightrelated (overweight/obesity) conditions. The aim of this study was to analyze the relationship between eating behavior style and psychophysiological responses (self-reported food craving and anxiety) to food-related virtual reality (VR) environments in outpatients with bulimia nervosa (BN) and binge eating disorder (BED) and to compare them with healthy participants. Fifty-eight outpatients and 135 healthy participants were exposed to palatable foods in four experimental everyday real-life VR environments (kitchen, dining room, bedroom and café). During exposure, cue-elicited food craving and anxiety were assessed. Participants also completed standardized instruments for the study purposes. ED patients reported significantly higher levels of craving and anxiety when exposed to the virtual food than healthy controls. Eating behavior styles showed strong associations with cue-elicited food craving and anxiety. In the healthy group, external eating was the only predictor of cue-elicited craving and anxiety. In participants with BN and BED, external and emotional eating were the best predictors of cue-elicited craving and anxiety, respectively